Put this formula in B1:
=INDEX(A:A,INT((ROWS(A$1:A1)-1)/3)+1)
then copy down to B12 (or further if you have more data in column A).
Hope this helps.
Pete
Put this formula in B1:
=INDEX(A:A,INT((ROWS(A$1:A1)-1)/3)+1)
then copy down to B12 (or further if you have more data in column A).
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks