Sort 15min (96) entries per day in single row

[edwardzbrown]

Hello, This is a data sorting question.

Sort 15min (96) entries per day in single row. This way each row has single date with a column for each 15 minute interval of every day instead of 96 rows of the same date end to end and only a single column of data entry.

Restated;
Currently, Column A = Date, Column B = time stamp by 15 minute interval, Column C = Data collected for that time and date.
What I want, Row A = Date 1, Row B = Date 2 And Columns B:CR = Data each 15 minutes collected that date.

I feel like my brain can get me half way there but the answer is eluding me. Thank you to everyone who reviews this and who is able to help me.

 

[Max1616]

Hello! Is the point of your question for viewing purposes only? If so, you should try pivoting the data. The current structure of your table is in the ideal format so you can slice & dice and structure it however you'd like via a pivot table.

Note the pivot set up on the right of the image below.

Hope this helps!

 

[edwardzbrown]

It does, I'm not a guru at pivot tables ,but knowing its possible gives me the motivation to go explore these more. If I still have trouble I'll come back. Thank you!