Combine Data in Multiple Columns to One Column Based on Data in Rows

bump, anybody, please?

i think you need to sort the rows and apply the formula that will work. please find the attached sheet.then you can sort
them with pizza,burgers....etc and get the highest count and total customers.


seems like this formula will help you....

add * as reputation if my answer helps you.

Originally Posted by boddulus

i think you need to sort the rows and apply the formula that will work. please find the attached sheet.then you can sort
them with pizza,burgers....etc and get the highest count and total customers.


seems like this formula will help you....

add * as reputation if my answer helps you.

thank you, but I am trying to have the data organized as follows. If I respectfully may, the spreadsheet you provided has the info kind of confusing like it was with my starting data.

Attachment 343958

Originally Posted by cs454

Hi exceldivx

Please find attached a workbook with the relevant formula. You will need to enter a user defined function in VBA.

Attachment 344128

edit:

To find 'Number of Contacts' is a simple COUNTIF:

=COUNTIF($B$2:$B$13,B2)

edit2:

In case you don't know how to enter user defined functions, press Alt+F11, click on your workbook in the project explorer on the left, open a new standard module and paste this :

Function Lookup_concat(Search_string As String, _
  Search_in_col As Range, Return_val_col As Range)
Dim i As Long
Dim result As String
For i = 1 To Search_in_col.Count
  If Search_in_col.Cells(i, 1) = Search_string Then
    result = result & " " & Return_val_col.Cells(i, 1).Value
  End If
Next
Lookup_concat = Trim(result)
End Function

ohh that's very close to what i need, thank you! how can i get rid of the duplicate data in column a, b, and c while retaining one copy of it, with the contacts name in that cell, as shown in the attached?

how can i also make sure the contact names that were combined are comma delimited?

Attachment 343958