Multiple Entries in Single Field (seperate data...?)
631584Sep 5 2008 — edited Oct 1 2008I have some mess of data and curious on if this can resolved simple from a query.
What I have, is multiple entries in a single cell. All the data is separated by pipes(|).
So, I have data similar to this in a table.(all made up of course :))..
Soda, coke|pepsi|dew|dtcoke,
Computer, dell|hp|gateway,
What I'm looking to do, is to turn these values into separate columns. So the final output would look
soda, coke
soda, pepsi
soda, dew
soda, dtcoke
computer, dell
computer, hp
computer, gateway
Any suggestions. And, sorry for the hefty examples. Figured more the better....
Edited by: Topher34 on Sep 5, 2008 9:20 AM