Hi all,
Could you please help me with this case:
I have Group name in one column and Item name in other column. Each item belongs to respective group in the on the left cell.
We want to have Group name as Column header and all items belong to the group in the column.
I tried transpose paste, pivot table but it didn't work.
Since I have more than 3000 items belong to 200 different groups, I would not prefer to do manual copy and paste.
Thank you very much for your help.
Could you please help me with this case:
I have Group name in one column and Item name in other column. Each item belongs to respective group in the on the left cell.
We want to have Group name as Column header and all items belong to the group in the column.
I tried transpose paste, pivot table but it didn't work.
Since I have more than 3000 items belong to 200 different groups, I would not prefer to do manual copy and paste.
Thank you very much for your help.
