Convert table rows to column

I have data like this:

ColumnName

row1

row2

row3

...

...

I want the result like this

row1        row2     row3     ...     ...

true        false     true     ...     ...

false        false     true     ...    开发者_运维问答 ...

Is this possible with PIVOT table? I have tried but unable to find any solution.

Thanks.

---

You should be able to use pivot. check out the link for a full explanation: http://msdn.microsoft.com/en-us/library/ms177410.aspx

---

Did you try Copy > Paste Special > Transpose option?

---

Or try following :

=TRANSPOSE(A1:A3) in destination cell.