Move cells to different row

[mollylmoriarity]

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.

[#2]

@mollylmoriarity 

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

Is this what you want to do?