I have data in an excel spread sheet that I want to import into a database. However the information is written on it's side (as such) e.g. My field names are going down Column A instead of going across Row1.
So I want this:
-----------------------------------------
Name | Ann | Mary | Barry | Tom |
-----------------------------------------
Age | 33 | 44 | 25 | 16 |
-----------------------------------------
Gender | F | F | M | M |
-----------------------------------------
to become this:
| Name | Age | Gender |
| .Ann.. | ..33. | F |
| .Mary | ..44. | F |
| .Barry | ..25. | M |
| .Tom. | ..16. | M |
Any help would be much appreciated.
Thanks.
Last edited by imeldajunk; 01-05-2012 at 07:32 PM.
Copy the table, and select an empty cell, right click your mouse > paste special > select transpose.
To thank someone who has helped you, click on the star icon below their name.
I hate reading
Portfolio
I need a job.I am young and incompetent
Ahhh yeah. Thanks a million ;-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks