Excel: Row value to columns
I have the following table:
Name Group
John 2A
John 1B
Barry 2A
Ron 1B
Ron 2A
Ron 2C
I wanted to know if there was any utility in Excel where I can separate
the group column into a new column of for each instance.
Expected Result
Name Group1 Group2 Group3
John 2A 1B
Barry 2A
Ron 1B 2A 2C
In this example I know that the max Groups are 3. So I made Group1,
Group2, and Group3 columns.
No comments:
Post a Comment