Sorting columns by rows

Hi, if anyone could help me with this it'd be much appreciated and save a lot of time compared to doing it manually;

I have in row 1 the time in 30 minute intervals
In each column I have registration plates, so if someone was parked at 7am they will appear in that column.
Due to the way the data was recorded, it was entered into excel quite chaotically and as such if someone was parked for 2 hours it is difficult to see this, as in the 7am column they may be in row 2 and in the 7.30am column row 20...

If anyone has any ideas on how I could sort all the columns so that the data in each column remains in the column but becomes aligned so that every instance of X7Z 123 is in the same row it would be appreciated.

I'm not really expecting a solution to this as I've already checked in other places and been told it would require some extensive visual basic programming, but thought I'd check just in case.

Thanks

Attached is an image of how the data looks, I'd like 1 row dedicated to each individual reg ...

Using Excel 2003