Stacking Horizontal Information?

[derekstewart]

Hi all. I have information about 2000+ vendors in the following format

Vendor Name Address Type
Vendor ABC 123 Washington Pl X, Y, Z,

The Type can contain up to 25 total values. We recieved this from a dept that has keyed all the types into a singe cell seperated by commas. I've split them all out using text to columns but this leaves me with horizontal info. I'd like to stack the info vertically, repeating the Vendor Name and Address and putting a single instance of each type per record. This will allow me to filter/pivot the Vendor Names by Type - actually use the data. I appreciate any assistance. Derek

 

[SkipVought]

Hi,

First create a table of just Vendor Name & Address.

Second in the original table DELETE the Address column, leaving Vendor Name and Type.

Parse Type on COMMA using Text to columns.

Use this technique to NORMALIZE the data...

faq68-5287

Once this is done, you can put the Address into your new normalized table, using the VLOOKUP function.

You may need to filter out and delete <blank> data rows.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[derekstewart]

Thanks Skip. Worked like a charm. Really appreciate it. Derek