For the wonderful world of DataSync, I need to populate a spreadsheet A that has many hundreds of columns, only say, 40 of which I need to fill. Needless to say they are not consecutive columns.
I can export the data I need from a separate database with those 40 columns, in the order I need, into a separate spreadsheet B. (approx 40 rows worth)
My goal is to hide the unneeded columns in Spreadsheet A, so only the 40 columns I need are showing. That I can do.
Then paste the columns from Spreadsheet A in to Spreadsheet B, with data only filling the visible columns, skipping the hidden columns. That, after much research, I can't do.
Ideally I would be able to do this from one sheet into another.
I've attached a png of a portion of Spreadsheet A, with unneeded columns hidden . (Last column is GPM--Anyone know how may total columns that is? Just curious)