Xlookup returing first value

[nosense]

Hi

when i am using xlookup only the first amount getting to the rest of the IDs, but the user worked on multiple languages, how to get the amount for each language without repeatin same amount. kindly help

 

[shili12]

use this formula
=CHOOSECOLS(FILTER(Sheet1!$A$1:$C$6,Sheet1!$A$1:$A$6=A2,"??"),1,3)'

 

[nosense]

thanks but this is not i am looking for

 

[vletm]

Could You show - what are You looking for?
= expected valid results

 

[Peter Bartholomew]

Many things are possible but I don't know what you are looking for. For example

= GROUPBY(IDs, HSTACK(languages, earnings), HSTACK(ARRAYTOTEXT, SUM),3,0)

will generate

 

[shili12]

Many things are possible but I don't know what you are looking for. For example

= GROUPBY(IDs, HSTACK(languages, earnings), HSTACK(ARRAYTOTEXT, SUM),3,0)

will generate
View attachment 90133

i believe the formula should be = GROUPBY(IDs, HSTACK(languages, earnings), HSTACK(ARRAYTOTEXT, SUM),0,0) to get below result

 

[shili12]

how to get the amount for each language without repeating same amount.

= GROUPBY(languages, HSTACK(IDs, earnings), HSTACK(ARRAYTOTEXT, SUM),0,0)