I am working with an OFFSET formula that was provided to me to help move
vertical data to horizontal data. In the original formula,
=OFFSET($F$1,ROW()*6-6+COLUMN()-18,) , I was moving 6 sets of vertical data.
Now I have 8 and the formula is not working. I am not sure how to
manipulate the numbers. I am assuming the "*6-6 refers to the 6 sets of data
and so I should change that to "*8-8", but I am not sure what the "-18"
stands for.