Converting a text file to an excel spread sheet

This is expanding on a question I had earlier but a little more complicated…..

I need to import a text file into excel and do the following: (SEE ATTACHED FILE)

Convert data in rows to columns deleting out information I do not need.
Data needed is Information on Object #, Name, Coordinates (X,Y,Z), Segment length, Number of Sheets welded, weld type.

Not all Objects have Coordinates and not all Objects have segment length.