Show only specific text from multiple rows in Cell that is adjacent to row

[cjohnr1388]

Basically from W4 TO AD573 there are paper sizes but there are all in there own columns. i need basically them to show in the column AE as one list but matching what is showing in the column of the same row... if that makes any sense.
If any one could help that would be very much appreciated. attachment below


OrderPaperTest.xlsx

[Pete_UK]

Put this formula in AE5:

=IF(W5="","",W5) & IF(Y5="","",Y5) & IF(AA5="","",AA5) & IF(AC5="","",AC5)

then copy down.

Hope this helps.

Pete

[cjohnr1388]

Once again you have solved my problem. Again much thanks