Combine multiple results in to 1 row

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...

Sample Doc How to merge multiple rows in to 1.xlsx2.2 MB

Formulas and Functions

Lorenzo
Apr 26, 2023
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

AndyT410

Brass Contributor

Apr 26, 2023

Thanks. Looks great. My company doesn't have power query installed and I'm not allowed to install it. But thanks anyway. It looks a lot simpler.

Lorenzo

Silver Contributor

Apr 26, 2023

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

Forum Discussion

Combine multiple results in to 1 row

Resources