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