Extract data from table to write at other tables

[misteree]

hi,

Assume i have a table that has information of customer and product they bought. is there any function(s) or function(s) combination that can help me to automatically write down the names of customer based on product? (can excel help me to create new tables based on products?)

Thank you

here i attach file for example, i try to automatically make new tables of student based on each subject.

[#2]

Hi @misteree

Please attached sample file with you desired result manually entered to advise you the correct solution 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

[#3]

thank you @Faraz Shaikh i attached the example and i made the table manually

[#4 · Accepted solution]

Hi @misteree,

Pls find attached solution for your query. If you have Microsoft365 (Office365) then you can take the advantage for these new dynamic arrays function or you need use the classic array 

I have attached both the solution for you.;)

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

[#5]

thank you @Faraz Shaikh, i try it already and it works perfectly.