Convert Column to Row

  • Thread starter Thread starter banker123
  • Start date Start date
B

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
 
banker123 said:
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
Click to expand...



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

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

Bill Ridgeway
 
Back
Top