Google Spreadsheet Post #2109
Reverse data horizontally
I have a massive spreadsheet of data that can grow horizontally and vertically. What I'm trying to figure out how to do is duplicare that data on another sheet only in reverse order horizontally using formulas or a script starting at column B. Is there a formula or script I can use to accomplish this? Keep in mind that the column and row numbers change so the formula/script needs to be able to change with it.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-14-2017
question by PY_:
https://productforums.google.com/forum/#!topic/docs/CZjRNAgMyUg;context-place=mydiscussionsReverse data horizontally
I have a massive spreadsheet of data that can grow horizontally and vertically. What I'm trying to figure out how to do is duplicare that data on another sheet only in reverse order horizontally using formulas or a script starting at column B. Is there a formula or script I can use to accomplish this? Keep in mind that the column and row numbers change so the formula/script needs to be able to change with it.
