Multiple codes in one field to multiple rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to take a column (Skills) that contains multiple codes (CO;WE;PS) etc.
and turn each code into a row. I tried using Switch, but that only works if
the Skills column has one code in it. Not sure if I need some sort of IF
InStr combo, and not sure how I would construct that. Any ideas?

tia.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple codes in one field to multiple rows? 1
edit fields to change multiple rows of data 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Access Dcount (multiple criteria) 3
one row of codes to multiple rows 12
Excel Delete Multiple Page Breaks w/in Selected Rows 6
Excel Help to copy information from one row at a time to another sheet 1
Merging multiple columns into one column (dynamically) 1

Back
Top