Combine multiple results in to 1 row

[AndyT410]

Hi,

I have a table with rep contacts on different product topics on different days to the same customer as below which are on different rows dependent on the date. Is there a formula that I could us to combine the rows by customer but still retain the date for each product topic. Thanks in advance.

[#2 · Accepted solution]

@AndyT410 

Glad this helped. If after checking the PivotTable it does what you expect please mark the solution (can help people who Search) - Thanks and nice EOD

[#3]

Looks right to me, Just need the last contact column.
company doesn't have power query installed

Have you solved this problem without PowerQuery?
If not, could you please provide your expected result.

I am not clear what you mean "last contact column".
Could you please provide some background of this question?
I am not sure what you want exactly.

[#4]

Hi, your attach file too many rows to be understood.
If possible, few rows may easy to catch what you want.

[#5]

Hi,
I've already solved it with that attached file. L.Z. was giving me a simpler option that I don't have the option to use. I added my solution in case it would help anyone else not looking for an answer but I don't know how to mark the thread closed. Thanks anyway.