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:
[TABLE="width: 655"]
<colgroup><col><col><col span="8"></colgroup><tbody>[TR]
[TD]Weekday[/TD]
[TD] Date[/TD]
[TD="align: right"]12:00 AM[/TD]
[TD="align: right"]1:00 AM[/TD]
[TD="align: right"]2:00 AM[/TD]
[TD="align: right"]3:00 AM[/TD]
[TD="align: right"]4:00 AM[/TD]
[TD="align: right"]5:00 AM[/TD]
[TD="align: right"]6:00 AM[/TD]
[TD="align: right"]7:00 AM[/TD]
[/TR]
[TR]
[TD]Friday[/TD]
[TD="align: right"]1/5/2018[/TD]
[TD="align: right"]0.87[/TD]
[TD="align: right"]1.18[/TD]
[TD="align: right"]0.91[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.71[/TD]
[TD="align: right"]1.07[/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]4.81[/TD]
[/TR]
[TR]
[TD]Saturday[/TD]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.64[/TD]
[TD="align: right"]1.02[/TD]
[TD="align: right"]0.9[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]1.29[/TD]
[TD="align: right"]0.99[/TD]
[/TR]
</tbody>[/TABLE]

This is what I have:
[TABLE="width: 200"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]11:00[/TD]
[TD="align: right"]0.61[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]12:00[/TD]
[TD="align: right"]1.5[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]13:00[/TD]
[TD="align: right"]3.94[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]14:00[/TD]
[TD="align: right"]6.48[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]15:00[/TD]
[TD="align: right"]5.11[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]16:00[/TD]
[TD="align: right"]5.21[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]17:00[/TD]
[TD="align: right"]3.06[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]18:00[/TD]
[TD="align: right"]7.26[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]19:00[/TD]
[TD="align: right"]2.48[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]20:00[/TD]
[TD="align: right"]1.3[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]21:00[/TD]
[TD="align: right"]0.94[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]22:00[/TD]
[TD="align: right"]1.2[/TD]
[/TR]
[TR]
[TD="align: right"]1/6/2018[/TD]
[TD="align: right"]23:00[/TD]
[TD="align: right"]0.88[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]0:00[/TD]
[TD="align: right"]0.65[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]1:00[/TD]
[TD="align: right"]1.93[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]2:00[/TD]
[TD="align: right"]5.01[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]3:00[/TD]
[TD="align: right"]0.82[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]4:00[/TD]
[TD="align: right"]0.75[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]5:00[/TD]
[TD="align: right"]0.73[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]6:00[/TD]
[TD="align: right"]1.13[/TD]
[/TR]
[TR]
[TD="align: right"]1/7/2018[/TD]
[TD="align: right"]7:00[/TD]
[TD="align: right"]0.65[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.