V Vkhara Jun 2, 2006 #1 is their any other way of transposing the data rather than using copy, paste special and transposing.
is their any other way of transposing the data rather than using copy, paste special and transposing.
A Ardus Petus Jun 2, 2006 #2 1) Use TRANSPOSE function 2) Use INDEX function with indexes based on ROW() and COLUMN() 3) Write a VBA proc HTH
1) Use TRANSPOSE function 2) Use INDEX function with indexes based on ROW() and COLUMN() 3) Write a VBA proc HTH
