Is there any way to conveniently accomplish this?

My data is organized like this:

4626859EX 5422369 4427272


What I am trying to do is get it organized like this

4626859EX 5422369 4427272
5422369 4626859EX 4427272
4427272 4626859EX 5422369


Rows of data up to eleven cells wide. Some rows have only one pairing,
others have anywhere between one and eleven. It would also have to insert the
blank rows for the 2nd, 3rd, 4th etc dells with data.

:-(

You need to provide considerably more detail about how the existing
data maps to the results data. E.g., why does 4626... occur twice in
the second column and not at all in the third? I don't see any
underlying logic in your example that illustrates how the mapping is
to be carried out.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]




On Thu, 6 May 2010 13:30:01 -0700, Iriemon
wrote:

Is there any way to conveniently accomplish this?

My data is organized like this:

4626859EX 5422369 4427272


What I am trying to do is get it organized like this

4626859EX 5422369 4427272
5422369 4626859EX 4427272
4427272 4626859EX 5422369


Rows of data up to eleven cells wide. Some rows have only one pairing,
others have anywhere between one and eleven. It would also have to insert the
blank rows for the 2nd, 3rd, 4th etc dells with data.

:-(