Import text file and sort the data

Hi Excel gurus,
I need your help with a spreadhseet that I am trying to put together. Basically, I need to import a text file (see 'Raw Data' tab), then sort it out (see 'End Result' tab), using a macro. So far I have been able to import the text file and sort it out using text to columns.

The 1st portion of the raw data tab sorts out the information by computer number and then username, and the 2nd portion is sorted out by username then by computer number. The data is dynamic, in the sense that information from the .txt varies from time to time, whenever the .txt is generated. I would like the last portion of the data to be omitted/deleted from the end result...this, I have no clue how to do.

The End Result tab is how I'd like the data to be organized, with headers. See the attached files..Excel file: access.xlsm Text file: report.txt

I am hoping that I passed along enough information..if not, then let me know.

**EDIT** - Some changes were made to the script that generates the .txt file, hence making it easier to sort the date.

Thank you