Hi,

I'm using excel 2007.

If I have 6 worksheets, and 5 of them have data, arranged in columns of varying length, how can I get the columns to run as one continuous column (ie with no blanks) on the first sheet?

A non-VBA answer please.