Forum Discussion
Solved
Unstack data from a double column
Hi, I have an excelsheet with two columns of data. In the first Column there are the units "Name", "Date", "Code", "Storage", "Origin" and sometimes "Descrption" and or "Place". In the second colum...
=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
Thanks mathetes, peiyezhu and OliverScheurich. for your help and solutions. This helped me alot sorting the original file with approx 12k rows.
I really appreciate your inputs and help.
Best, M