Combining RowsI hga

[BillMac63]

I have an Excel file with multiple rows per person. Col A is the unique identifier. I need to combine all rows for each person into one row. No person will have more than four rows, but some may have 2, 3 or 4. Is this possible?

Thanks
Bill

[BillMac63]

What I need to do is export one record per respondent in ASCII format. I do have access to SPSS for the export if necessary

[oeldere]

One row separted by comma (,) or all values in differents cells.

For both solutions has Jerry Beaucaires an solution.

See the link below.

https://sites.google.com/a/madrocket...ssistant/files

[BillMac63]

Thank you for that information.

However this is not quite what I need to do.

For example, if I had the following 4 rows:

0001 AAAA
0001 BBBB
0001 CCCC
0001 DDDD

Then I need my final output to look like:

0001 AAAA BBBB CCCC DDDD

Any ideas?

Thanks again
Bill

[oeldere]

2 things:

1) you don't give an anwer on my question under #3.

2) Did you look at the link I added under #3?