Example of a transposed table in Excel export

In our example, the form contains the input fields Customer and Order number. After that there is a table with the fields Product, Price and Quantity. The following entries were made here as an example:

Customer: Smith
Oder number: 1234

The transposed export would look like this:

Customer	Order number	Product	Price	Quantity
Smith	1234	Trousers	100€	2
Smith	1234	T-Shirt	20€	1
Smith	1234	Socks	10€	4

A not transposed (normal) export would look like this:

Customer	Order number	Product1	Price1	Quantity1	Product2	Price2	Quantity2	Product3	Price3	Quantity3
Smith	1234	Trousers	100€	2	T-Shirt	20€	1	Socks	10€	4