Row 1 is A B C D 1 2 3 4 5
Row 2 is A B C D 6 7 8 9 0
Row 3 is A B C D 9 9 9 9 9
A B C D are the same values for each line.
I want to eliminate the duplicates and make it look like this:
Row 1 A B C D 1 2 3 4 5
Row 2 6 7 8 9 0
Row 3 9 9 9 9 9
How can this be done? when I create a pivot table, the count will be 1 instead of 3 ?
Bookmarks