I have this table (it can be in Access or Excel).
Name--ID--Email--Cat1--Cat2--Cat3
Mr.A--1-- e@mail.com--wat--dfgf--uytyt
Mr.A--1-- e@mail.com--some--fgdfd--fgfd
Mr.A--1-- e@mail.com--stri---hgfgf--ghfgh
Mr.A--1-- e@mail.com--fdgf--fddf--gdfdf
Mr.B--1-- e@mail.com--fwat--vdfgf--xuytyt
Mr.B--1-- e@mail.com--vsome--rfgdfd--xfgfd
Mr.B--1-- e@mail.com--gstri---fhgfgf--gghfgh
Mr.B--1-- e@mail.com--cfdgf--rfddf--sgdfdf
and I want to keep all this information in 1 row like this (since there are 4 records for each)
Name (Mr.A)--ID--Email--Cat1--Cat2--Cat3--Cat1--Cat2--Cat3--Cat1--Cat2--Cat3---Cat1--Cat2--Cat3
Name (Mr.B)--ID--Email--Cat1--Cat2--Cat3--Cat1--Cat2--Cat3--Cat1--Cat2--Cat3---Cat1--Cat2--Cat3
Thank you