Forum Discussion
Help with Data Analysis
Hi, I have >17000 rows of data, where the data (rows) is grouped or associated with a single cell in the row above the section of data as I've tried to represent below. So rows 2 & 3 are associated w...
Reme1000 That would be a job for Power Query. The attached workbook contains an example of what it can do, with very little code writing. The basic steps are to connect to a table, add a custom column (here you need to type a formula similar to an Excel IF function, but simpler), fill-down and unpivot.
If you are not familiar with Power Query, you may want to have look here first:
https://exceloffthegrid.com/power-query-introduction/
Perhaps a bit overwhelming at first but you will soon get the hang of it.