Rows into dynamic columns

[lavadan]

I have a table with name and Amount

Name Amount
rita 100.00
rick 100.00
sam 150.00
harry 200.00
heather 290.00
James 200.00

I was wondering if I can do a dynamic pivot on Amount Column so that my result will be

100 150 200 290
Rita Sam Harry Heather
Ram James

 

[johnherman]

select distinct (amount) from table union select name from table;

then use powershell or unix shell to convert the carriage return/line feed characters to space.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity