In my worksheet I rows of values as follows in individual cells
ABC 72 30 DEF 67 20 GHI 77 33 JKL 80 12
DEF 77 23 GHI 77 34 ABC 73 31 JKL 81 13
and so on.... The same text will not always be in the same column
What I'm trying to do, is then create a list that will return the values as
follows:
ABC DEF GHI JKL ABC DEF GHI JKL
72 67 77 80 30 20 33 12
73 77 77 81 31 23 34 13
Hope this has made sense