How To Group This Table ?

[sellingherbal]

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

[June7]

Unless there is an identifier that can be used select all 1 records, all 2 records, all 3 records, all 4 records, this won't be easy.

You can use Allen Browne's ConcatRelated function to combine the data into a single string http://allenbrowne.com/func-concat.html.

If you want to keep the data as discrete elements (separate fields), will need more complicated code and write records to a temp table.

[sellingherbal]

Unless there is an identifier that can be used select all 1 records, all 2 records, all 3 records, all 4 records, this won't be easy.

You can use Allen Browne's ConcatRelated function to combine the data into a single string http://allenbrowne.com/func-concat.html.

If you want to keep the data as discrete elements (separate fields), will need more complicated code and write records to a temp table.

Thank you, I tried this method but got an error every time (even with the same numbers etc... in the thread's attached picture).
http://stackoverflow.com/questions/1...alue-in-column

[June7]

I tested the spreadsheet code with the example data from that thread and it works for me without error. What error do you get?

It will certainly require some adjustment to deal with your 3 columns of data.