Convert table rows to column

I have data like this:

row1

row2

row3

...

...

I want the result like this

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.