How To Classifying Data In Horizontal

[d2pren]

Hi guys! Help me...
I have a table like the left image. And I want group it like right above image. So the result is like a Bottom Right image.
ac492fdeed794029bf5a8b9fa7ba4ff7.png
Please help me how to do it.
Thank You!!

[hoyasaxa215]

Column and Row labeling would be helpful. If your data table starts in B2 and your entering your list of names in F2 (my best guess from above), then you would enter the formula below into cell G2 as an ARRAY (ctrl+shift+enter) and copy over and down. You may have to adjust the references as necessary:

Please Login or Register  to view this content.

[d2pren]

Column and Row labeling would be helpful. If your data table starts in B2 and your entering your list of names in F2 (my best guess from above), then you would enter the formula below into cell G2 as an ARRAY (ctrl+shift+enter) and copy over and down. You may have to adjust the references as necessary:

Please Login or Register  to view this content.

This formula not work if I change NUMBER to WORD, example:
apel one
apel three
jeruk six
jeruk two
jeruk five
mangga four
mangga seven

Can you give me formula/script again with this change?

[hoyasaxa215]

It still works for me when i change from numbers to words. Can you upload a sample file showing your use of the formula and how it isn't working?

[d2pren]

It still works for me when i change from numbers to words. Can you upload a sample file showing your use of the formula and how it isn't working?

Sorry, I miss something. And your formula work so great. Thank you