A small amount of GAS scripting is needed for this project.
1) I select ONE cell per column (holding control)
2) I run your script that does:
A) Processes the selection the user made to obtain the coordinates of every cell
B) It gets the lowest selected cell (the one taht belongs to the row with highest index)
C) It runs a for cycle for every column that determines the "distance" (in cells) between the selected cell of that column and the lowest selected cell.
D) The script finally runs the command "Insert cells and move down" before every selected cell.
The goal is simply represented in the screenshot I attached to the project, where with one script run, I will have all columns aligned for the cells I selected.
4 威客就此工作平均出价 €30
Hello, I was recently working with GAS for another company, I could deal with this within 1-2 hours. Leave me the message if you're interested. Best regards, Dawid Rudnicki