Separate fields

[gtamir1]

Hi, I get data from a database as shown in the picture. Line 1 and 9 are the main transaction, and lines 3-8 are what I call Sub Transaction. they belong to the main transaction, describing the elements comprises the main part. 
How can I separate all fields to columns and values?
In short, I want all lines to be one line of fiels names and values.

[gtamir1 · Accepted solution]

Thanks for your answer. Meanwhile the customer says he will send the data in another format so I don't want to buther you whith that.

[lbendlin]

Please provide sample data in usable format (not as a picture) and show the expected outcome.