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 - 24 Jan 2008 13:25 GMT
>I have a table:
>
[quoted text clipped - 7 lines]
> 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