Feb 04 2021 07:30 AM - edited Feb 04 2021 08:11 AM
Hi
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.
Feb 04 2021 08:43 AM - edited Feb 04 2021 08:44 AM
You can make your headers dynamic by using
=TRANSPOSE(SORT(UNIQUE(Table3[Role])))
in D1
Then, in D2 enter
=SORT(FILTER(Table3[Position]:Table3[Position],Table3[Role]:Table3[Role]=D1))
and copy/paste towards the right. Do NOT drag the formula to the right.
Please find a mock-up attached.
Feb 04 2021 09:57 AM
Thanks a lot for the great example
Feb 04 2021 11:17 AM
@nailuenlue Tried that but can't think of a way right now.