Imported text files aligning data

[robertjtucker]

Hello all hope everyone is having a good day,
Ok my issue that I am having is that I am importing report text (.txt) files into excel so the employees can take the information and convert into charts and such. what I am dealing with is sometihing like this, it is broken down by item and lists all the purchasing information below it.
a...........................b.....................c..........................d
1 item id.................plner................buyer...............req date
2 1234.....................me....................me...................01/01/05
3
4 po#...................supplier...........qty....................promise date
5 P->abc123.........the store.........5.......................01/05/05
6 P->def456.........abc store.........10.....................02/06/05

OK I need row a2 infront of rows a5 and a6 or something like that. And there is no consistancey, other than the basic format.

Thanks for the help everyone,
Bob