Move Rows and Old Columns added to new sheet

swolf

I'm trying to move a single row to a different sheet, but I don't want the columns from the original sheet to be copied over as well. Is there a way to avoid this? Whenever I try to move the row, it also brings the columns from the original sheet, which I don't want.

Kerry St. Thomas

If using a Move/Copy Row automation or menu command, every column in the source sheet is brought to the destination sheet if it doesn't already exist. The only workaround I've been able to come up with is questionable at best: it severs the data flow, so would create difficulty recreating data if needed. It also has issues with scalability, because it could tie you inextricably into continuing down this path even if it's no longer needed. BUT… here's the workaround I've used - it leverages Data Shuttle. If you have that premium app, read on:

—Step one is to OFFLOAD the entire sheet using Data Shuttle. Have it offload to be attached to the DESTINATION sheet on a regular cadence - I suggest no more frequently than every day, at way-too-freaking-early-o'clock in the morning.
—Step two is to UPLOAD the data to that destination sheet. Have that workflow trigger on attachment, and map only specific columns to be uploaded.

If you decide to move forward with this, good luck! If not, the other option is to go ahead and let those columns be pulled into the destination sheet and just hide them. :)