Mar 16 2022 08:46 AM
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.
Mar 16 2022 09:21 AM