A completely formula based solution without helper column
I am considering example from 1st post and assuming that your example from post #1 ranges from A1 and goes till F7
below formula is to extract the numbers in one column from data copy paste below formula in H1 then hold Ctrl+Shft and then Hit enter to make it array
drag down
now in I1 use below formula and then drag down and drag right to get result, copy paste below in I1 and the hold CTRL+SHIFT and then hit enter
change the ranges to suit your need
if this helps then add reputation by clicking little star button at the bottom of this post
Bookmarks