I have check other methods for doing this but none of the solutions seem to match what I want.
My horizontal list is like this:
A 1
A 2
A 3
A 4
B 1
B 2
B 3
B 4
C 3
D 1
D 2
D 3
And I want it to look like this:
A B C D
1 1 3 1
2 2 2
3 3 3
4 4
If anyone can help with some formulas or vba code, I'd be grateful.
Thanx Paula.
Bookmarks