Forum Discussion
DMcCauley5082
Oct 26, 2021Copper Contributor
Lots of data, need help organizing into usable format
I have an insurmountable amount of data that I’m trying to move into a more user-friendly format to then run statistical analyses. I am using Microsoft 365, Excel Version 2102 64-bit on a Windows 10....
DMcCauley5082
Oct 26, 2021Copper Contributor
Riny_van_Eekelen I, unfortunately, am not familiar but will go some Google searching and watch a few videos to see what I can learn about it. Thanks for pointing me in a starting direction!
Riny_van_Eekelen
Oct 26, 2021Platinum Contributor
DMcCauley5082 You'll find a good start here:
- DMcCauley5082Oct 26, 2021Copper ContributorRiny_van_Eekelen I've going to try these unstacking steps and see what I get.
https://exceloffthegrid.com/power-query-unstacking-data-in-a-column/