I’m hoping someone can help – I have used text to columns to split out products that had been entered into one cell and were separated by a comma. I then ran a macro to duplicate the rows based on the number of products to give each product its own row of data.
But now I’m stuck as I don’t know how to clean up the products so that I am left with 1 column that shows each individual product allowing me to delete columns 2-6. So in the example below this would result in a column that contained BIOL23, BIOL33, MICR3, BIOL5 AND MICR2.
I have 5 helper columns because I have instances of up to 5 products entered into one column!
Any advice would be appreciated.
<tbody>
</tbody>
But now I’m stuck as I don’t know how to clean up the products so that I am left with 1 column that shows each individual product allowing me to delete columns 2-6. So in the example below this would result in a column that contained BIOL23, BIOL33, MICR3, BIOL5 AND MICR2.
I have 5 helper columns because I have instances of up to 5 products entered into one column!
Any advice would be appreciated.
Count | Column2 | Column3 | Column4 | Column5 | Column6 | Type | Note | EntryID |
3 | BIOL23 | BIOL33 | MICR3 | | | PART | Computation | 8 |
3 | BIOL23 | BIOL33 | MICR3 | | | PART | Computation | 8 |
3 | BIOL23 | BIOL33 | MICR3 | | | PART | Computation | 8 |
2 | BIOL5 | MICR2 | | | | IND | Computation3 | 56 |
2 | BIOL5 | MICR2 | | | | IND | Computation3 | 56 |
<tbody>
</tbody>