Convert Column to Row

[banker123]

I have a table:

ID Price Quantitiy
1 1.00 2


I would like to convert the original table to something like this:
This is a small sample of a much larger table.

ID Measure Data
1 Price 1.00
1 Quantity 2

 

[Bill Ridgeway]

I have a table:

ID Price Quantitiy
1 1.00 2


I would like to convert the original table to something like this:
This is a small sample of a much larger table.

ID Measure Data
1 Price 1.00
1 Quantity 2

Copy the columns(s) you want to place into row(s)

Use <Paste Special><Transpose> to put the data into rows.

Bill Ridgeway