Forum Discussion
Solved
Excel: Help with putting a subheader into a column
Hi! I need help transforming the headers into a column. The row next to each header is always "Summing row", so I need a way to go from ie header1 to header2 based on when the summing row appears...
You can try Power Query. Enter the data in the blue dynamic table. Then click in any cell of the green table and right-click with the mouse and refresh. According to the sample data the assumption is that there are always 3 names under each header and 3 categories under each summing row.
Thanks. Sadly, there is not three names under each header, I just wanted to create a simple example instead of the messy Excel file I'm trying to clean up.
I was thinking something like IF "summing row" is present then copy the cell to the left of "summing row". Repeat until "summing row" appears again, then repeat the loop, but I can't wrap my head around how to do it.