Lookup & output of multiple values related to ID in column

Hi folks!

I would really appreciate your help for solving the following excel
problem, as it is quite urgent:


I have a table like this:
A B C D E
|CustomerID|Product |Product X |Product Y |Product Z |
|1 |X | | | |
|1 |Y | | | |
|2 |Z | | | |
|3 |X | | | |
|3 |Y | | | |
|3 |Z | | | |


If a customer uses multiple products, there are multiple rows with the
respective product.


I would need the aggregated information about the used products per
Customer in one Row, so that the sheet looks like that:
A B C D E
|CustomerID|Product |Product X |Product Y |Product Z |
|1 |X |1 |1 |0 |
|1 |Y |1 |1 |0 |
|2 |Z |0 |0 |1 |
|3 |X |1 |1 |1 |
|3 |Y |1 |1 |1 |
|3 |Z |1 |1 |1 |


Does anybody know a solution for this (preferable no VBA)?


Thank you so much in advance!!!!!!


kr,
Stefan

Thanks a lot, you are a star!!! The formula works well, but an other problem occured now.

As I have about 50.000 rows, the calculation of the cells causes an system error, due to running out of memory, when copying the formulas to all cells.

I guess, the only solution for this will be a macro to set only the values and to avoid running out of memory. Unfortunately I don't know vba coding that well.

Do you know a solution for that?

that worked now...

thx a lot for your quick help!!!!