I'm trying to figure out a script to automate the transfer of data from a column on one sheet, to one of four columns on another sheet. The data being transferred is an order that has been placed, so the data needs to stay in the column its transferred to until it is received. So basically the script needs to find the next blank column and transfer the data there.

For reference, the sheet is HERE:

In case you are wondering what this does:

[...Array.from(Array(4).keys(), x => x   5)]

It just feeds the four column numbers into the reduce loop current value