Hi,
New here and trying to solve a problem that is really annoying me at the moment could anyone please help.
Using a formula I need to compile the three columns (number, colours and letter) into one column, each on top of one another without any gaps (gaps can vary from 1 row to an empty column). This would only be for 3 columns and over a range of rows, in this case 15.
Apologies now for the poor table :-S
1.JPG
to this:-
2.JPG
Please any help would be greatly appreciated!!
Bookmarks