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.

1 comment:

  1. Hi,

    Trying to implement this. Struggling to make it grow . Using the exact formula I only seem to get cell A1 and A2.

    I literally have Rows 1 and 2 that grow horizontally. New data appears in cells A1 and A2 (using importrange) and bumps old data along but I would like to reverse this. So that old data is in A1

    ReplyDelete