Hi, I'm sure this has been asked, but don't even know how to look it up. I have a spreadsheet that needs to have a pivot table created off it. The data looks like the following:
Workflows
Loan #
Age
The Row will be the workflows, the column will be the age and the data will be a count of loan #'s. They want anything over the age of 30 to be all grouped together. So the age will be 0 - 30+
Is there a way to do this and easily? I will have to teach others how to accomplish it on a daily basis.
Thanks
Dianna
Workflows
Loan #
Age
The Row will be the workflows, the column will be the age and the data will be a count of loan #'s. They want anything over the age of 30 to be all grouped together. So the age will be 0 - 30+
Is there a way to do this and easily? I will have to teach others how to accomplish it on a daily basis.
Thanks
Dianna