Transposing data

V

Vkhara

is their any other way of transposing the data rather than using copy,
paste special and transposing.
 
A

Ardus Petus

1) Use TRANSPOSE function

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

3) Write a VBA proc

HTH
 
Top