Saturday, January 14, 2017

yogi_Reverse Entries In Sheet Named Data Horizontally (except for entries in first column)

Google Spreadsheet   Post  #2109
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=mydiscussions
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.