This is my 1st post, so apologies if I miss anything.
In brief, I have a column of numeric data that is 6241 rows long.
I want to populate (or transform) that data into a 79x79 table. The 79x79 is a customer's form, so it cannot be modified and my data must fit/conform exactly within this 79x79 grid.
I could copy the first 79 rows worth of entries and paste into a column, then copy the next 79 rows of data into the adjacent column, and so on until I have a 79x79 grid, but I would wager there is a more efficient way to do this, and since I will likely need to do this operation quarterly, I would like to know if there is a formula that I can use.
I do NOT know VBA or SQL.
Can anyone help me? Thanks!
In brief, I have a column of numeric data that is 6241 rows long.
I want to populate (or transform) that data into a 79x79 table. The 79x79 is a customer's form, so it cannot be modified and my data must fit/conform exactly within this 79x79 grid.
I could copy the first 79 rows worth of entries and paste into a column, then copy the next 79 rows of data into the adjacent column, and so on until I have a 79x79 grid, but I would wager there is a more efficient way to do this, and since I will likely need to do this operation quarterly, I would like to know if there is a formula that I can use.
I do NOT know VBA or SQL.
Can anyone help me? Thanks!
