That works too.

Thank you

The non-PIVOT solution works fine, and I should have thought of it.

Just curios though. Could the same thing be done with less code using PIVOT?

Works like a charm.  I will share.

Thank you very much.

[font="Times New Roman"]Don't get old. :hehe:[/font]

THANKS FOR THE RESPONSE. I WAS THINKING ABOUT THAT NOW THAT I HAVE CONFIRMATION THAT THE EXTERNAL DATA HAS A UNIQUE IDENTIFIER.

I PREFER NOT TO GROUP BECAUSE I HAVE SEVERAL OTHER COLUMNS THAT NEED TO BE INCLUDED IN THE OUTPUT.

THANKS. I DON'T SUPPOSE THERE IS A WAY TO THIS WITHOUT USING A GROUP BY?

Thanks for the post. I was made aware of the tally table method yesterday.

However, I would like to keep the split results in the same row in multiple columns....

Thanks guys. You've given me something verging on excitement.

I would be interested in anything you've got. There will be future changes on additional spreadsheets.

Thanks

Thanks guys. This seems to be a much more palatable and viable option.

I'm using Excel 2003. Do you mean "Import External Data"? Please be more specific. We have many spreadsheets with data imports to more than 10 tabs each. Can the data...

When I query master..sysprocesses I only get 1 record.

I'm using Windows XP Pro. My default device for sound playback is Sound Blaster Audigy.

I don't have program events. I'm using Windows XP Pro.