Hello Everyone,
I'm really having trouble solving this - it's driving me crazy.
I have a set of data with some duplicate ID's in column A. If the ID is the same, I would like to concatenate the values in the columns to the right with the rows below, but only if they're different. I found a couple of related questions on this site, but can't seem to relate it directly back to my issue here. I tried nested IF statements, but can only figure out how to compare 2 rows, if there are more than 2 duplicate IDs - my formula would not identify them and consolidate into 1 row.
I'd be extremely grateful for anyone who can help me out. See below for an example (not the actual data I'm working with):
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Here's what I would like the final result to be:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I'm really having trouble solving this - it's driving me crazy.
I have a set of data with some duplicate ID's in column A. If the ID is the same, I would like to concatenate the values in the columns to the right with the rows below, but only if they're different. I found a couple of related questions on this site, but can't seem to relate it directly back to my issue here. I tried nested IF statements, but can only figure out how to compare 2 rows, if there are more than 2 duplicate IDs - my formula would not identify them and consolidate into 1 row.
I'd be extremely grateful for anyone who can help me out. See below for an example (not the actual data I'm working with):
ID | Name | Order |
1 | Jack | Chicken |
1 | Jill | Pork |
2 | Jack | Chicken |
3 | Jack | Rice |
4 | Jill | Chicken |
4 | Jack | Chicken |
4 | Jack | Pork |
4 | Jill | Rice |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Here's what I would like the final result to be:
ID | Name | Order |
1 | Jack, Jill | Chicken, Pork |
2 | Jack | Chicken |
3 | Jack | Rice |
4 | Jill, Jack | Chicken, Pork, Rice |
<colgroup><col><col><col></colgroup><tbody>
</tbody>