I am trying to synthetize clients Data in order to do clustering. My problem is for 1 customer I have severals rows. I would like to synthetize informations to get 1 row per customer. This clustering is about how customers use fidelity program. Here is a picture of my table : By Column (left to right) :
My question is how could I have 1 customer per row without loosing informations. Maybe Pivot Table? But I don"t know how it work exactly. I am new to statistic btw.