Not really sure where to look and pretty new to Pivot Tables but here goes.
This is how the data lays out in our spreadsheet.
Name | Address | Date | Check # | Amount
I need to create a pivot table that lays out as follows. There are some fields where we don't have info (i've showed those with null)
is this possible?
Name | Address | Date 1 | Date 2 | Date 3
person 1 | address 1 | amount$ | Amount$ | Amount$
person 2 | address 2 | amount$ | null | null
person 3 | null | null | null | Amount$