shavenlunatic
MIS
Hi,
Looking for an alternative to using pastespecial transpose here. I am trying to avoid scanning each cell and passing the values accross
The two methods I am hoping are possible are as follows:
take this data as an example
First method:
Load this data into a 2D array and rotate the array, then place the data on a sheet in the new arrangement (not sure if there is a function to rotate an array, but I am trying to avoid scanning each part of the array and doing basically the same as I mentioned above with the cells)
Second Method
Grab the range of data (would even be happy doing it row-by-row) and transposing it into another sheet, but avoiding using pastespecial for the obvious reasons.
I doubt if either of these are possible and I expect I am going to have to loop through all of the data and do it cell by cell, but I was hoping to find a "neater" method.
Any help appreciated and thanks in advance
________
clueless
Looking for an alternative to using pastespecial transpose here. I am trying to avoid scanning each cell and passing the values accross
The two methods I am hoping are possible are as follows:
take this data as an example
Code:
A B C D
1 t h i s
2 d a t a
3 n e e d
4 s a i d
First method:
Load this data into a 2D array and rotate the array, then place the data on a sheet in the new arrangement (not sure if there is a function to rotate an array, but I am trying to avoid scanning each part of the array and doing basically the same as I mentioned above with the cells)
Second Method
Grab the range of data (would even be happy doing it row-by-row) and transposing it into another sheet, but avoiding using pastespecial for the obvious reasons.
I doubt if either of these are possible and I expect I am going to have to loop through all of the data and do it cell by cell, but I was hoping to find a "neater" method.
Any help appreciated and thanks in advance
________
clueless