Vertically Combining data from multiple columns to have all data in 1 column

Hi guys,

Struggling to find an answer to this one!

I have product id's in multiple columns that I need a formula that can combine all of the non-blank cells in those columns into one long list on another tab.

Google sheets can do this with the formula =FILTER({A2:A;C2:C}, LEN({A2:A;C2:C})) but this won't work on Excel.

The few that I found online aren't doing the the trick! I've created an example sheet which shows the source data on tab 1, and the desired output on tab 2.

Any advice?

SKU LIST EXAMPLE.xlsx

UPDATE: I've actually found this formula from another thread, which worked on 2 columns, how do I adapt it to pull data from columns C,D,E & F?

=LET(a,C2:C1000,b,D2:D5000,ra,ROWS(a),s,SEQUENCE(ra+ROWS(b)),c,IF(s<=ra,a,INDEX(b,s-ra)),FILTER(c,c<>0))

pls try this formula

Formula:

Please Login or Register  to view this content.

OR

Formula:

Please Login or Register  to view this content.

Thanks for your rep.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

Thanks all! TOCOL is a new one for me but it worked perfectly!