1 List Ends another Starts

[Broobi]

Hi All

Hoping someone can help

I have two lists, from two pivot tables, each from an external separate data source. What I'm trying to do is have a formula that lists both into one. So, lets say i have 1 list starting in A1 to A20 and the other from B1 to B20... in C1, I need a formula that would start a list from A1, keep going until it gets to the end of A20 then continue with B1 to B20?

Hope that makes sense?

I've tried using INDEX and vlookups, but I can't seem to get it

Any suggestions would be greatly appreciated!

Many thanks :D

[TMS]

In the absence of a workbook and data, try this:

Please Login or Register  to view this content.

Regards, TMS

[Broobi]

That appears to have worked great

Many thanks for your help! :D

[TMS]

You're welcome. Thanks for the rep.