Append text in a column field in a table from duplicate rows from another table

[rkaczano]

I am removing duplicates from a table (into second table) AND appending text values from that first table in a given column. I am unsure how to approach the append portion of that logic.

I have a table with duplicates (column C) . In that table, there is a field (column D) that has text values that can vary by commas (1 or 1,14, or 16,64 etc). I am pulling the data from table 1 into a second table that is using the Unique function to remove the duplicates values in column C. But I also need to append the values from duplicates that I removed from column D in the first table.

The formula below in the second table checks to see if its row (I6) returns a count = 1 in the first table, if so, this implies no duplicate exists and simply pulls the value over to the second table from $D$6:$D$230. I need an Else condition that appends the values in column D for the duplicates if the Countif equals > 1. I need to copy this formula down so that it fully populates the second table.

=IF(COUNTIF($C$6:$C$230,I6)=1,XLOOKUP(I6,$C$6:$C$230,$D$6:$D$230),APPEND VALUES)

Thanks

 

[Peter_SSs]

Any chance that you could give us a small set of sample data and the expected results with XL2BB?