I have a data set in one long column, something like 16,000 numbers. The numbers are organized in sets, in the first set there are 168 numbers per set, but in the future there will be more or less. I would like to cut the 168 numbers, paste into a new column, then go to the next 168 numbers below the first 168 and paste them. ..I tried an offset such as
"
in B1
offset(A171,,,counta(168))
in C1
offset(A338,,,counta(168))
"
This is what i can do manually, but i would like to do this automatically as the data sets can be up to 500,000 at times..
Bookmarks