Hello,
Have a question for excel. I have a sheet with a large list of records. Each record has an ID, but is not unique due to multiple attributes which need to be accounted for, for each ID. Because these records are split, what I am trying to do is build another column at the end of my spreadsheet which will combine all the data from each unique ID into one cell. I will try to show below. Please notice, the combination of A2:B3 are duplicates, I wanted to include this in the example because I want to make sure if there are duplicates, I want to remove those from the results. I would put carriage returns in the results area.
<tbody>
</tbody>
Have a question for excel. I have a sheet with a large list of records. Each record has an ID, but is not unique due to multiple attributes which need to be accounted for, for each ID. Because these records are split, what I am trying to do is build another column at the end of my spreadsheet which will combine all the data from each unique ID into one cell. I will try to show below. Please notice, the combination of A2:B3 are duplicates, I wanted to include this in the example because I want to make sure if there are duplicates, I want to remove those from the results. I would put carriage returns in the results area.
A | B | C | |
1 | ID | Type | Results |
2 | A-123 | Cat-big | Cat-big Cat-small Dog-big Dog-small Dog-tiny |
3 | A-123 | Cat-big | Cat-big Cat-small Dog-big Dog-small Dog-tiny |
4 | A-123 | Cat-small | Cat-big Cat-small Dog-big Dog-small Dog-tiny |
5 | A-123 | Dog-big | Cat-big Cat-small Dog-big Dog-small Dog-tiny |
6 | B-123 | Dog-small | Dog-small Dog-tiny |
7 | B-123 | Dog-tiny | Dog-small Dog-tiny |
8 | A-987 | Cat-tiny | Cat-tiny |
9 | A-777 | Cat-large | Cat-large |
10 | A-555 | Bull-large | Bull-large Bull-skinny |
11 | A-555 | Bull-skinny | Bull-large Bull-skinny |
<tbody>
</tbody>