Awkward Data Set - Any ideas to get a better soloution

[JordanJackson]

Hi there, 

The problem i'm having is that the data thats been produced is broken into columns of energy usage for every half an hour throughout the day. 

This would be great to see this for each day, however the format of the excel in powerbi looks at the trend of each individual half an hour over time instead. 

I need a way to change the data so that I can see each half an hour when looking at different days. I believe this may involve some pivoting/unpivoting shanagans but any help would be greatly appreciated. 

Thanks in advance.

[amitchandak]

@JordanJackson , Based on what I got you can unpivot the half hour columns

https://radacad.com/pivot-and-unpivot-with-power-bi