Create multiple records from single record

[robshiffer]

I have data on several different vendors, which includes all of the vendor's locations in a single record. What I want to be able to do is create an individual record for each vendor location combination

e.g.

from

vendor 1	3	xyz	3	xyz	Chicago	Tom Jones	Houston	Jon Doe
vendor 2	2	xyz	2	xyz	New York	Jim Smith	LA	Betty White	SF	John Smith

to

vendor 1	3	xyz	3	xyz	Chicago	Tom Jones
vendor 1	3	xyz	3	xyz	Houston	Jon Doe
vendor 2	2	xyz	2	xyz	New york	Jim Smith
vendor 2	2	xyz	2	xyz	LA	Betty White
vendor 2	2	xyz	2	xyz	SF	John Smith

Any help is appreciated! Thanks!

[MarqueeCrew]

@robshiffer,

Elegant, no.  Does the job?  I think so.

This isn't very dynamic, but the approach may work for you.

Cheers,

Mark

[BenMoss · Accepted solution]

In this sort of scenario, transpose, multirow are your friends, I've attached a solution that should help get you to where you need to be!

Please reach out if this doesn't suit!

Ben