Good day people,
I have a list that looks like this
I need it to look like this
Help would be very appreciated. About a year ago one of your members helped me with the same issue.
However that solution doesn't work at all anymore.
If it helps, all my "Names" are in A column, and all the "things" are in the B column.
I have a list that looks like this
Name | Thing |
Bob | apple |
Ann | pear |
Marie | dog |
Bob | cat |
Marie | white |
Ann | red |
George | black |
Ann | purple |
I need it to look like this
Bob | apple | cat | |
Ann | pear | red | purple |
Marie | dog | white | |
George | black |
Help would be very appreciated. About a year ago one of your members helped me with the same issue.
Help with Transposing
Here's an example: John apple John fridge John heart John pear John car Steven soap Steven display Steven pen Steven orange Steven bee I would like it to look like, John apple fridge heart pear Car Steven soap display pen orange bee My sheet is mostly...
www.mrexcel.com
However that solution doesn't work at all anymore.
If it helps, all my "Names" are in A column, and all the "things" are in the B column.