av8tordude
06-08-2011, 01:59 PM
I need a code that will look into each cell in column B and find each city separated by “/” and separate each city (along with the rest of the information) into its own row. (See Attached)
For example…
California | Antioch / Brentwood / Concord | Contra Costa | $1.00 | $2.00 | $3.00
California | Antioch| Contra Costa | $1.00 | $2.00 | $3.00
California | Brentwood| Contra Costa | $1.00 | $2.00 | $3.00
California | Concord | Contra Costa | $1.00 | $2.00 | $3.00
For example…
California | Antioch / Brentwood / Concord | Contra Costa | $1.00 | $2.00 | $3.00
California | Antioch| Contra Costa | $1.00 | $2.00 | $3.00
California | Brentwood| Contra Costa | $1.00 | $2.00 | $3.00
California | Concord | Contra Costa | $1.00 | $2.00 | $3.00