Resorting / Reformatting data in columns to different layout

I have attached a sample sheet with Raw data on it, as well as How I want to have the data resorted. Basically, tracking a customer through a sales cycle, and I want to be able to see if they hit certain stages (the sort column)

So I am trying to figure out how to generate a listing of a customer number, customer name, and then an "x" (or whatever) in the appropriate box so that i know they have hit that state.

A company may appear more than once in the same stage... (for example Company A has Sort A twice..... if that happens, only one mark is needed in Column M, and that company needs to appear only once).

A company may not hit all of the stages in order as well.

The sample sheet has raw data in columns A through D

Columns K through Q, is how I would want it to look.

Any help/thoughts are greatly appreciated

**** Update ****

Column B will contain a date that the last customer hit a certain stage. If there is a way to pull only the most recent date that the customer hit that part of the cycle, that would be awesome... if not, it is not a big deal.