Hi all
My requirement is to convert the layout as bellow:
before:
column1 column2 column3
1 A 1
1 B 1
1 C 2
2 A 1
2 C 1
convert to :
column1 A B C
1 1 1 2
2 1 0 1
The detail requirement is first to select all the customers and then to get the customers sales informations . the customer's name should be the internal field name .
can anyone give me some suggestions? thanks a lot.