Hi,

Am Thu, 6 May 2021 16:19:52 -0500 schrieb dpb:

It has anywhere from 4-8 separate sections corresponding to monthly
scholarship billings that are extracted from the workbook Financial Aid
sends as the bill to the Foundation; we have to then code the funds to
which individual awards are to be billed internally to/tracked by the
Foundation by the source of the funds.

try:
Options = Quick Access Toolbar and add "PivotTable and PivotChart
Wizard"
With that tool you can choose "Multiple consolidation ranges"

or have a look:
https://www.contextures.com/xlpivot08.html


Regards
Claus B.
--
Windows10
Microsoft 365 for business