excel help- trailer maping

hello i just stumbled across this forum and read up some stuff on the trailer yard inventory but nothing that really helped me.

my issue is i have a big lot with alot of trailers that go in and out, some are stationary.
on a seperate software i can print out log of all the trailers that have cheked in, now my question is:
is there any way to upload that log to excel ( i tested this and i can upload it) so that it maps it out for me in order. for example

pad A and to list all the trailer #'s that are in order, then do pad b and list all the trailer #'s in order for that pad. and so on for as many rows as i have


so basicaly id like to upload the file into excel and have it auto sorted into a "map" so this is what id like it to look but just mapped in excel
https://ibb.co/i1kKiR

<a href="https://ibb.co/i1kKiR"><img src="https://preview.ibb.co/hz2bV6/D3_AA5487_92_F3_4_AC5_8674_40747_AFE32_BE.jpg" alt="D3_AA5487_92_F3_4_AC5_8674_40747_AFE32_BE" border="0"></a><br /><a target='_blank' href='https://imgbb.com/'>high res image hosting</a><br />

i dont know if this is possible or not but i would gladly accept any help on this! thank you