Loading...
Uploaded by ExcelIsFun on Dec 8, 2009
See how to transpose a range (switch rows and columns) using INDEX, COLUMNS and ROWS function. If you dont want to use TRANSPOSE function, this is a good substitute.
Science & Technology
Standard YouTube License
Hi, I have a more complicated set of data that requires transposing
here is how it looks like: paste2. org/p/1215016
have you done sth like this in any of your videos?
knrd87 1 year ago
No i do not. No problem. Try THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 1 year ago
@ExcelIsFun
I'll do that, thx
Load more suggestions
Hi, I have a more complicated set of data that requires transposing
here is how it looks like: paste2. org/p/1215016
have you done sth like this in any of your videos?
knrd87 1 year ago
No i do not. No problem. Try THE best Excel question site:
mrexcel[dot]com/forum
ExcelIsFun 1 year ago