LinkBack URL
About LinkBacks
I have a 15X26 matrix in an excel sheet. How do I quickly put each column under the first with out copy>paste? End result I am looking for is a 390 row long colum with all the data. Thanks
I have a 15X26 matrix in an excel sheet. How do I quickly put each column under the first with out copy>paste? End result I am looking for is a 390 row long colum with all the data. Thanks
It would help if you specified some ranges but if we assume the matrix is A1:Z15 and results are to be listed in AB1:AB390 then
AB1:
=INDEX($A$1:$Z$15,CEILING(ROWS(AB$1:AB1)/26,1),1+MOD(ROWS(AB$1:AB1)-1,26))
copied down to AB390
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That's basically what I want, but I want it to read down the colums. So the first 15 numbers are A1:A15, then after that B1:B15, C1:C15 etc.
In which case simply invert the logic
AB1:
=INDEX($A$1:$Z$15,1+MOD(ROWS(AB$1:AB1)-1,15),CEILING(ROWS(AB$1:AB1)/15,1))
copied down
Awesome, thanks for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks