Hello,

I am having trouble using the OFFSET function. I have several columns with varying row lengths that I am trying to combine into one column. I was trying to program so that it would go through all the rows in one column until it reached a blank cell (using the =if(ISBLANK()=True,) then it would offset to the top of the next column and begin copying those rows.



I have attached an example and appreciate any help to solve this issue:

OFFSet.xlsx