auto convert unique row data to columns

[iRounak]

Please see the attached worksheet. I want the table in the right side to be dynamically auto-generated from the unique items in the table in the left.

Thanks.

[rylo]

Hi

Pretty crude, but should get you there.

Please Login or Register  to view this content.

rylo

[iRounak]

Thanks.
I have marked the thread solved and added to the answerer's reputation but if there is a better solution please post it because I do not know why exactly is this solution "crude".