Turn on the macro recorder, then record your steps, but as modified
below:

1. File|Open the WordPad (text?) file. Let it import into Column A with
the remaining data parsed out into the other columns (this can be
specified during the file import operation.
2. Select Column A and insert a new column.
3. Select Row 1 and insert a new row, if there are no column labels in
your text file.
4. Format Row 1 to be Bold, with cell underline.
5. Delete unneeded columns.
6. Sort by Column B.
7. At this point you will have to figure out how to locate the
unnecessary rows and delete them.
8. Resort by Column A.
9. Delete Column A.

Post a short example of what raw data you have here, if you can,
especially the unnecessary rows.
We may be able to provide some help from there.
--
Regards,
Bill Renaud