How to group rows of data without wiping any columns

Get Help
1

Hello!

I'm currently trying to produce a report using our Hubspot data.

What I want to see is the date the deal moved to Closed Won then the date the deal moved to Live (deal stages)

I've found all the data I need but when I visualise it it creates multiple rows per deal. One row for the Closed Won date then one for the Live date.

I can't figure out a way to group it together so in Column A I'd have the deal name, B the Closed Won date and C the Live date.

Any help would be appreciated!

Thanks,

2

Is there ever only one value in each column per deal? If so you can use a Summarize by Maximum of the Closed Won and Live columns and it should collapse the null rows. This works as long as the deal identifier is the same.