I am combining data in several columns into one singlecolumn using this formula:
=OFFSET(AccRange,MOD(ROW()-ROW(ColumnData),ROWS(AccRange)),TRUNC((ROW()-ROW(ColumnData))/ROWS(AccRange),0),1,1)
I’m using named ranges: AccRange = columns I’m combining; ColumnData = column where I’m placingall my...