Hi All,
I am now struggling to seek a quick way to convert below table into the preferred layout.
example
example.PNG
the array I usually receive is over 100*100, what I am currently doing is to transpose and copy and paste all the combination and proceed the index/match look up.
I am looking forward for suggestion from you guys.
Thank you so much! :)
Regards,
Bookmarks