I have data that gets offset and split into 3 rows. I would like to reverse the offset and bring it back to 1 row.
I have data that gets offset and split into 3 rows. I would like to reverse the offset and bring it back to 1 row.
Is this what you mean?
=INDEX(Offset!A:A,(ROW(A1)-1)*3+2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks