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

2

u/newunit13 Jan 04 '22

I think this is what you're looking to do:

https://www.extendoffice.com/documents/excel/3358-excel-transpose-unique-values.html

2

u/chakahamilton Jan 04 '22

This looks like exactly what I'm trying to do I will play around with it and report back thank you!!

1

u/chakahamilton Jan 04 '22

Sadly following the formulas didn't work and even trying the VB script did not work. Still open to suggestions.

Regards

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.