Forum Discussion

aaashton's avatar
aaashton
Copper Contributor
Jun 10, 2022

Help with a pivot

Hello, I have a spreadsheet that has columns Deal Name, Owner, Phase 1, Phase 2, and Phase 3.  The Phase columns will have the date the deal has completed that phase; so it can be blank if not compl...
excel
mathetes's avatar
mathetes
Gold Contributor
Jun 10, 2022

aaashton 

 

This seems to work:

First the raw data

Then the pivot table instructions (dialog box)

And the resulting pivot table

Spreadsheet attached

 

Resources