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!
Solved! Go to Solution.
Elegant, no. Does the job? I think so.
This isn't very dynamic, but the approach may work for you.
Cheers,
Mark