|
|
Post by blue van man on Jul 17, 2007 20:53:27 GMT
Anyone know how to convert a row to a column?
I've imported a massive file in from TXT, delimited it successfully, but it's displayed as a row. I'm running Office 2007
help please
|
|
blindwizard
New Member
Ex Advisor Hillside. Not in Blinds anymore
Posts: 4
|
Post by blindwizard on Jul 17, 2007 23:15:03 GMT
Copy Row then paste using right click but choose "PASTE SPECIAL" and tick the box "TRANSPOSE" and voilà job done
|
|
|
|
Post by blue van man on Jul 18, 2007 9:57:12 GMT
Copy Row then paste using right click but choose "PASTE SPECIAL" and tick the box "TRANSPOSE" and voilà job done Thanks BW, sorted. Although I had to copy to a different sheet or I got an error message saying areas overlapped. But done, great |
|
