Move cells to different row

Occasional Visitor

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

PartPrevent BookingQuality HoldContract ReviewCompliance ReviewQuality Shipment HoldAdvance Payment Hold
ang123Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD     
ang234Contract Review Hold, PREVENT BOOKING, Quality Hold     
ang235Contract Review Hold, PREVENT BOOKING, Quality Hold     
ang236PREVENT BOOKING     
ang237Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD     
ang238DAV ADMINISTRATIVE HOLD, PREVENT BOOKING     
ang239Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD     
ang240Contract Review Hold, PREVENT BOOKING, Quality Hold, QUALITY SHIPMENT HOLD     
ang241Contract 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.

1 Reply

@mollylmoriarity 

=IF(ISNUMBER(SEARCH(C$1,$B2)),$A2,"")

Is this what you want to do?