Forum Discussion
Move cells to different row
I have a raw set of data that contains a list of categories (separated by a comma) in one column. I need each category to be shifted under the correct column. How can I set up an automated function?
Example
| Part | Prevent Booking | Quality Hold | Contract Review | Compliance Review | Quality Shipment Hold | Advance Payment Hold |
| ang123 | Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD | |||||
| ang234 | Contract Review Hold, PREVENT BOOKING, Quality Hold | |||||
| ang235 | Contract Review Hold, PREVENT BOOKING, Quality Hold | |||||
| ang236 | PREVENT BOOKING | |||||
| ang237 | Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD | |||||
| ang238 | DAV ADMINISTRATIVE HOLD, PREVENT BOOKING | |||||
| ang239 | Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD | |||||
| ang240 | Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD | |||||
| ang241 | Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD |
This is how the data pulls. I need for example if the cell has 'contract review hold' to be moved to 'contract review hold' column in that same row. I can do text to column but the categories do not end up under the right column.
