Convert Rows into Columns

[krotha]

I want to convert rows into columns. Can anyone help me writing the query.
I have table like this:
Trype Index Value Id
A 1 19223 13758834.01
A 2 Account Type1 13758834.01
A 3 USD 13758834.01
A 4 2% 13758834.01
A 5 13758834.01
A 6 13758834.01
A 7 1000482 13758834.01
A 8 19223 13758834.01
A 1 19224 13758834.01
A 2 Account Type1 13758834.01
A 3 USD 13758834.01
A 4 2% 13758834.01
A 5 13758834.01
A 6 13758834.01
A 7 1000482 13758834.01
A 8 19223 13758834.01
A 1 18224 13800
A 2 Account Type1 13800
A 3 USD 13800
A 4 2% 13800
A 6 13800
A 7 2999292 13800
A 8 18224 13800
A 1 18225 13800
A 2 Account Type1 13800
A 3 USD 13800
A 4 2% 13800
A 5 13800
A 6 13800
A 7 2999292 13800
A 8 18225 13800

And I want results like following
Id Account_Number Account Type Currency Rate Rate_Change Term Customer_Number Value Number
13758834.01 19223 Account Type1 USD 2% 1000482 19223
13758834.01 19224 Account Type1 USD 2% 1000482 19223
13800 18224 Account Type1 USD 2% 2999292 18224
13800 18225 Account Type1 USD 2% 2999292 18225

 

[LNBruno]

Search function broken again?

Try this:

http://www.tek-tips.com/faqs.cfm?fid=2146

< M!ke >
Your right to an opinion does not obligate me to take you seriously.
- Winston Churchill