Good morning all,
Long time viewer of these forums. I have a problem that I am totally stumped on. This is an example of the spreadsheet I've been using for estimating expenses for projects, and now I am trying to generate reports from it using pivot tables. Any idea to accommodate the offset of the columns ? Ideally I'd have the pivot table look like this:
-Concrete forming
-concrete forming
- form
- place
I tried running power query last night, and it looked a lot better. But I still cant get look with the offset I want (yet).
Long time viewer of these forums. I have a problem that I am totally stumped on. This is an example of the spreadsheet I've been using for estimating expenses for projects, and now I am trying to generate reports from it using pivot tables. Any idea to accommodate the offset of the columns ? Ideally I'd have the pivot table look like this:
-Concrete forming
-concrete forming
- form
- place
I tried running power query last night, and it looked a lot better. But I still cant get look with the offset I want (yet).