Dynamic transpose based on additional rows

Occasional Contributor



Due to the great support I got here, I would like to use your knowhow on the following problem..I would like to add additional columns based on the row entries in another column. The Screenshot should explain the problem.



3 Replies


You can make your headers dynamic by using




in D1


Then, in D2 enter




 and copy/paste towards the right. Do NOT drag the formula to the right.


Please find a mock-up attached.


Thanks a lot for the great example Is there a way to make the D2-Part dynamic as well (without the need to copy paste the formula)? As the left list grows, the columns on the right are added and the references (positions) are listed below (the numbers in your example).

@nailuenlue Tried that but can't think of a way right now.