Hi,
I have a worksheet of the format below. I would like to rearrange the values in columns A B and C so I end up with one row and the cell entries currently in A1, B2 and C3 all in the same row. Simple to do manually but I actually have 11000 rows to sort through, any help would be most welcome.
A B C D
1 4 X
2 5 X
3 6 X
End up as one row.
A B C D
1 4 5 6 X
I have tried to think of a way of doing it by some kind of lookup, but am stummped!
Thanks Phil...
I have a worksheet of the format below. I would like to rearrange the values in columns A B and C so I end up with one row and the cell entries currently in A1, B2 and C3 all in the same row. Simple to do manually but I actually have 11000 rows to sort through, any help would be most welcome.
A B C D
1 4 X
2 5 X
3 6 X
End up as one row.
A B C D
1 4 5 6 X
I have tried to think of a way of doing it by some kind of lookup, but am stummped!
Thanks Phil...