Transposing data

  • Thread starter Thread starter Vkhara
  • Start date Start date
V

Vkhara

is their any other way of transposing the data rather than using copy,
paste special and transposing.
 
1) Use TRANSPOSE function

2) Use INDEX function with indexes based on ROW() and COLUMN()

3) Write a VBA proc

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transposing list of numbers 2
Really simple macro problem - I bet! 2
Transpose Address Data 7
transpose data 3
Eliminate blanks while copy row and transpose 11
Transpose Microsoft Query 2
Transposing 0
LINEST multiple known_x's separated arrays 5

Back
Top