advanced table match

[tothepoint]

Hi, what i would like to do is the following... I have a large list which includes the names of persons and an answer to a single question. Let's say i have 600 records from 150 unique persons (multiple answers per person). I want to create a table within excel where the answers per person are appended to a record with the name of the individual. The new table should have only 150 records with the answers appended to the individual records.

I don't seem to be able to solve this with digdb. Any ideas?

[DigDB Support]

Just to clarify, so you have a large list like

Name    Answer
aaa      1
aaa      2
bbb      3
...

And you want a list like

Name    Answer
aaa      1, 2
bbb      3
...

right?

Do the following:

1. Click a cell in your list
2. Invoke Excel->DigDB->Unique->Extract Uniques->from Table Column(s)
3. Use first dropdown to select the "Name" column
4. Tick the "optional" filed, use the 2nd dropdown to select the "Answer" column
5. click ok.

You can try this in a small table a few times to get a hang of how it works, then apply it on your large table.