I have a worksheet containing a large amount of data, with one character per cell, in the following format :-
1 a x
2 b y
3 c z
I want to manipulate the data to be as follows, again with one character per cell:-
1 a x 2 b y 3 c z
I have done this before using 2 different methods, 1 complicated and 1 simple which I stumbled across. Trouble is I can't find either method.
Any help would be appreciated.
Kind regards
duffsparky
Bookmarks