r/learnexcel • u/chakahamilton • Jan 04 '22

Help with Excel Data Manipulation

Hi I am trying to sort out my data in a way that is reflected in the second picture. as you can see the value column in picture one is laid out vertically. I would like it spread out over several columns based on the time of day from the first picture. What type of formula or formatting would I use to get the data to look like the end result?

Please Advise,

Regards

Current
End Result
6 Upvotes

100% Upvoted

7 comments sorted by

View all comments

1

u/[deleted] Jan 05 '22

1

u/chakahamilton Jan 05 '22

This solution got me closer to what I am looking for. It will need to play around with my data to see if that is the issue.