I apologize in advance if my entry will lack in any way and/or if my question has already been answered previously.
I am using Excel and I need to remove the duplicates of column A without losing the values of column B. This is what i have:
A B
------
a x
a y
a z
b y
b z
c x
c z
What I need is something like this:
A B
------
a x,y,z
b y,z
c x,z
By using the remove duplicate function I and up with the following:
A B
------
a x
b y
c x
Excel keeps only the value in the first row and deletes the values of all other duplicates of column A.
