derekstewart
MIS
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
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