Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

Note:
All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog

4/25/2013

How to transpose a table in Excel

I didn't know. But this is how it works:

Take any table













Press CTRL* to select the entire table














Now copy CTRL-C

And paste special (plakken speciaal) . Make sure to click box Transpose (transponeren)


















Press OK


No comments:

Post a Comment