Reformulate Hourly Columns and Daily Rows into DateTime Stamped Data

Some dataloggers provide hourly averaged data presented in columns, with each row representing a day and each hour being represented as a value in a column (24 columns for hourly representation). Processing this data using analysis tools or importing into time-sequenced DBs is tricky in this format. It is MUCH easier to have each individual datapoint timestamped.

A great way to do this is with a routine based on the EDT unpivot function with some extra steps. A nice example of that is shown here:

1 Like

Just wanted to also share an alternative method to do a similar process centered directly around the Gather function

Daily average of the input data format can be directly calculated using the “Pivot” function in EDT:

1 Like