Forum Discussion
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 When you mention "an insurmountable amount of data" that you want distribute over a number of columns with texts and number is crying out for Power Query. Are you familiar with that?
Am not able to send you a demo right now, but I'm sure that someone else will.
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!
DMcCauley5082 You'll find a good start here:
- Riny_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/
