troubleshooting Question

Excel Pivot Table Display Data Custom

Avatar of axessJosh
axessJosh asked on
Microsoft ExcelSpreadsheets
7 Comments2 Solutions76 ViewsLast Modified:
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$
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros