I have a spreadsheet that has a worksheet for every day of any given month, is there a way that I can create a pivot table that will include the data range for every day?
I've been looking but no luck as such.
Cheers up front
I have a spreadsheet that has a worksheet for every day of any given month, is there a way that I can create a pivot table that will include the data range for every day?
I've been looking but no luck as such.
Cheers up front
There are two ways.
1. Use Power Query (preferred)
2. Use Multiple Consolidation Ranges as the pivot source.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks