Hi Ya'll,
I have a table I'm importing that looks like this
Customer Name Smith Brothers
Product A
Price of A
Quantity of A
Product B
Price of B
Quantity of B
Product C
Price of C
Quantity of C
and is a single row per customer.
I'd like to convert this table into a real table like
Customer Name, Product Name, Product Price, Product Quantity
Smith Brothers A 2.44 3
Smith Brthers B 2.44 1
Smith Brothers C 5.34 6
Is there a simple way?
I have a table I'm importing that looks like this
Customer Name Smith Brothers
Product A
Price of A
Quantity of A
Product B
Price of B
Quantity of B
Product C
Price of C
Quantity of C
and is a single row per customer.
I'd like to convert this table into a real table like
Customer Name, Product Name, Product Price, Product Quantity
Smith Brothers A 2.44 3
Smith Brthers B 2.44 1
Smith Brothers C 5.34 6
Is there a simple way?