Excel 2007 : Multiple Variable Length Lists to 1 List

Hi,

I'm wondering if anyone can help me with the following problem:

I have a series of lists, let's say 4. Depending on input, each list will vary in length (#rows filled and not blank) to a max of 150 rows each. They all have x, y and z coordinates.

I want to combine these lists in one list with no blanks without having to copy and paste each separate list or filtering.

Note...I don't know VBA! Or how to input a Macro...though I do love excel and hope to learn one day!!

Thanks for your time.

Sarah

Thanks!

I knew I should have included one…please find an example spreadsheet attached. I didn’t use the original as it was a little overly complicated; however, not sure if this means that I’ve left something important out.

Please let me know if more information would be helpful.

Thanks again,

Sarah

Awesome!! Thank you. It's definitely working the way I want it to. I'm going to try and figure out the functions and see if I can replicate it for my slightly more complicated spreadsheet

Thank you so much!!!