Hi there,
I have an excel spreadsheet with 43 columns 381 rows, I need to switch these around so that the data in the rows is in columns and vice versa, but keeping the order of the data (its a very complex rota).
I googled this and found the copy>paste special>transpose function, however i have had some problems with this. Whenever i select paste special>transpose etc, a box pops up telling me the cells are different sizes and therefore cannot be pasted. Some of the cells are empty and some are different colours.
Does anyone know a solution for this or perhaps a different method of achieving the same thing?
On a similar line, this is something that will need to be done annually for a few spreadsheets and is quite laborious. I was wondering if anyone may give me some advice on if i can and how to create a program/forumla to do this automatically? I thought it may be possible through VBA.
I am running Excel 2003 on a windows XP machine (at work so i dont have admin privilidges)
Many thanks for any help
Bookmarks