A small tweak to the formula:
=INDEX($A:$A, (ROW($A1)*11)-11+COLUMN(A$1))&""
You won't see any zeros this way.
A small tweak to the formula:
=INDEX($A:$A, (ROW($A1)*11)-11+COLUMN(A$1))&""
You won't see any zeros this way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks