Need to combine data programatically.
Here is my spreadsheet
369 Medical Authorization/Utilization
370 Apportionment
370 Settlement
371 Apportionment
371 Settlement
372 Apportionment
For my final results I would like to see
369 Medical Authorization/Utilization
370 Apportionment, Settlement
371 Apportionment, Settlement
372 Apportionment
So I a column has a duplicate value, I would like to combine those into one
row and delete the row after combining. There could be more than two
matches.
Any ideas on how to do this?
|