Version 184.108.40.206 - LibreOffice Calc
I need to change a linear data set into a matrix spreadsheet.
I have a raw data set for electrical load of certain off grid buildings. At the moment the first column has date and time from 00:00 - 23:45 for every day in this format (mm/dd/yyyy 00:00). In the neighboring right column there is the corresponding kW value for that time. There are several months of data that I must sort through.
I would like to change the structure and create a matrix. I would like to have the dates as the columns, the time as the rows, and would like to fill the kW values correctly within matrix (corresponding to its correct date and time).
I have months of this data and I would rather not enter it all in by hand. Does anyone have any suggestions or shortcuts?
Thanks for any help