Hi there, I've had a look around the forums for an answer to this but haven't found anyone with a similar issue. Apologies if it's been answered before.
so what I have is a datasheet with five columns:
A: User Id
B: Category of item for sale
C: Brand 1 of item for sale
D: Brand 2 of item for sale
E: Brand 3 of item for sale
But what happens is I receive this data with only the first three columns filled out. That is, there are duplicates of the User ID in the rows, and these user IDs may have different categories and different brands. What I want is to consolidate the Brands into a single row for each User ID and Category of item.
e.g. Raw data:
A001 Category 1 Brand 1
A002 Category 1 Brand 1
A001 Category 1 Brand 2
A001 Category 2 Brand 4
A002 Category 1 Brand 2
A001 Category 1 Brand 3
A001 Category 2 Brand 5
that I want to end up looking like this:
A001 Category 1 Brand 1 Brand 2 Brand 3
A002 Category 1 Brand 1 Brand 2
A001 Category 2 Brand 4 Brand 5
A002 Category 3 Brand 2
I hope this makes sense. Is there any easy way of doing this? The Consolidate command only appears to work for numbers..
Many thanks in advance!
Bookmarks