techieWannabe
MIS
Hi,
I want to convert rows that have the same ID but additional data to one single row where the additional data would go to new columns.
For example:
ID Name Rate DistrPerc
-----------------------------------------
111 Amy 25000.00 5
111 Amy 30000.00 6
222 Bob 28000.00 2
and change it so it would look like this...
ID Name Rate1 DistrPerc1 Rate2 DistriPerc
-----------------------------------------------------------
111 Amy 25000.00 5 30000.00 6
222 Bob 28000.00 2
I want to convert rows that have the same ID but additional data to one single row where the additional data would go to new columns.
For example:
ID Name Rate DistrPerc
-----------------------------------------
111 Amy 25000.00 5
111 Amy 30000.00 6
222 Bob 28000.00 2
and change it so it would look like this...
ID Name Rate1 DistrPerc1 Rate2 DistriPerc
-----------------------------------------------------------
111 Amy 25000.00 5 30000.00 6
222 Bob 28000.00 2