I've been really scratching my head but I can't figure this one out...

I have 3-4 worksheets (depending on the job) that I want to combine
into one. The data may exist on some sheets but not others. These can
get very large when combined (17 columns and over 10,000 rows).

What I need is a way that will combine the following values as an
example from this data on 3 rows, where each of these values is in it's
own cell:


12 17 4 john smith
3 4 7 john smith
45 4 2 john smith

to this, with all of the values on one row:

12 17 4 3 4 7 45 4 2 john smith


I may also have situations where I'll have this:

12 17 4 john smith
john smith
45 4 2 john smith

but I need this:

12 17 4 45 4 2 john smith


I have created macros that move the values and delete the now-empty
rows, but with over 10,000 rows, it's extremely time consuming...

Any help?

Vern
I can help you with this but I'm not clear on what you have and not
clear on what you need help with. For instance, in your example with 3
rows, are each of those 3 rows on different sheets? Were they ever on 3
different sheets? Do you need help starting with the 3 or 4 sheets or is it
that you need help after you have combined the data from those sheets?
If you wish, send me your file or a file that represents/displays what
you have and need help with. My email address is .
Remove the "nop" from this address. HTH Otto
"Vern Halen" wrote in message
oups.com...
I've been really scratching my head but I can't figure this one out...

I have 3-4 worksheets (depending on the job) that I want to combine
into one. The data may exist on some sheets but not others. These can
get very large when combined (17 columns and over 10,000 rows).

What I need is a way that will combine the following values as an
example from this data on 3 rows, where each of these values is in it's
own cell:


12 17 4 john smith
3 4 7 john smith
45 4 2 john smith

to this, with all of the values on one row:

12 17 4 3 4 7 45 4 2 john smith


I may also have situations where I'll have this:

12 17 4 john smith
john smith
45 4 2 john smith

but I need this:

12 17 4 45 4 2 john smith


I have created macros that move the values and delete the now-empty
rows, but with over 10,000 rows, it's extremely time consuming...

Any help?