Can the limitations be overcome by reducing the size of data being transposed at the time of action?
Can the limitations be overcome by reducing the size of data being transposed at the time of action?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
I suppose, but sometimes the data is the data and you just have to work with it. If I am honest the code is better without the use of TRANSPOSE.Originally Posted by Aussiebear
TRANSPOSE is limited to the same amount of rows as old excel I believe.
Posting Permissions
Reply With Quote
