Arrange data from a 24hr cycle to by day rather than by hour

[edwardzbrown]

Hello,

My power company exports my energy use by hour. I want to arrange years worth of data by day with all the hours of a day to the right of that day's row. That way I can compare energy use by hour and even by day of the week. What would be the best way to go about organizing this?


This is what I want:

Weekday	Date	12:00 AM	1:00 AM	2:00 AM	3:00 AM	4:00 AM	5:00 AM	6:00 AM	7:00 AM
Friday	1/5/2018	0.87	1.18	0.91	0.67	0.71	1.07	0.62	4.81
Saturday	1/6/2018	0.69	0.64	1.02	0.9	0.56	0.6	1.29	0.99

<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>

This is what I have:

1/6/2018	11:00	0.61
1/6/2018	12:00	1.5
1/6/2018	13:00	3.94
1/6/2018	14:00	6.48
1/6/2018	15:00	5.11
1/6/2018	16:00	5.21
1/6/2018	17:00	3.06
1/6/2018	18:00	7.26
1/6/2018	19:00	2.48
1/6/2018	20:00	1.3
1/6/2018	21:00	0.94
1/6/2018	22:00	1.2
1/6/2018	23:00	0.88
1/7/2018	0:00	0.65
1/7/2018	1:00	1.93
1/7/2018	2:00	5.01
1/7/2018	3:00	0.82
1/7/2018	4:00	0.75
1/7/2018	5:00	0.73
1/7/2018	6:00	1.13
1/7/2018	7:00	0.65

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

 

[edwardzbrown]

Ohh, I found a way that works. I used a data Filter. I filtered by each hour of the day, copy and paste it over into my spread sheet. I just needed to do this 24 times to import my entire data set. Not too terrible.