Forum Discussion
Unstack data from a double column
=COUNTIF($A$2:A2,"Name und Autor")An alternative could be Power Query along with a helper column with this formula. In the attached file you can add data to the blue dynamic table. Then fill the formula down from cell C2 to the end of the table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Hi mathetes
Of course, i also added a screenshot below. I have only put the first 300 lines in the file.
In the picture row 2-6 are one dataset - I would like to have the values of each dataset in one row instead of one column. To make it a bit more complicated, some of the datasets have 1-3 additional statements.
Thanks & Best, M
https://1drv.ms/x/s!AtkdbFqXXz0Ugymk-S7YsZe59_7S?e=tlb0xJ
Well, here's a "quick and dirty" solution. I'm sure it could be more elegant, but I'm also assuming this is a job that just needs to be done once.
I've attached an Excel sheet that shows the process getting started. Using the CHOOSEROWS function, and here's a reference on that function.