Combining subsequent cells in rows to primary cell in row automatically with changing data

[aarbogust]

I am using Excel to extract external data from a table on the web. The table is a report from Cosential which is n online program that tracks an enormous amount of data from projects that we work on.

We need this data formatted, filtered, and sorted differently than the program has to offer so our management can easily read the desired information.

So i exported the data and it is working great. (Even tho i dont completely understand how the connection works.

However, I noticed that one of the field does not extract all the information into one cell. It places it all under the (what I will call) primary row.

http

s://mmccorp.egnyte.com/dl/CVNuynbcUu

If you can see the image you will notice the names that fall under the primary rows. I need all the names to be combined into the row that is primary to the project and separated by a dash. This needs to happen for each "primary row.

I may have to create a whole new sheet to combine it as all this information continually shifts up and downs as the information is updated with in the program that am extracting from. But maybe you all know better than me. This function that is created will have to always update as the sheet updates. Remember that information is imported here by query so i will not be inputting information manually. (I don't want to have to manually run a macro.)

Assume the column that is staff team name is column R. The Primary rows are the ones with information in the columns to the left with the most distinct difference between primary rows being the Opportunity name Column Assume the Opportunity Name column is column K

In the end i want anyone to be able to open this sheet and the information is complete and updated with out them having to do anything except "enable content"and "trust this sheet"

Thank you for your help!!

 

[aarbogust]

So for some additional clarifying info: Where the sheet reads Hampton Inn - Keller I need all the names under this to be in the primary cell that reads marty hoffey and separated by a dash. I need it separated by a dash because i have a UDF that deletes all spaces and lower case letters leaving me with dashes and upper case letters which is the initials of each individual.

(The end result i am going for is the initials of each of these people associated with each job in one cell. if you have a solution to get to this, that is what i need, but if a solution to just get the subsequent names into one cell on the same row as the primary row then i can take it the rest of the way.)