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!!