Table A
User ParameterA ParameterB ParameterC ParameterD ParameterE
Jim x x x
John x x x
Dave x
Henry x
Jim x
John x
Dave x
Henry x
Table B
User ParameterA ParameterB ParameterC ParameterD ParameterE
Dave x x
Henry x x
Jim x x x x
John x x x x
How can I transform table A into Table B, see my earlier post for
attachment, (there are no viruses or macros attached to it). I basically
want to remove duplicate user names, but preserve and combine the parameter
fields.
Any help would be appreciated.
Regards,
David.
Bookmarks