Forum Discussion
Power query data from a calendar worksheet
I have a calendar data that shows construction crews as headers. The row underneath categorizes each crew as either "hardscape" or "softscape". All the rows beneath shows what jobs they did in 2022. I need a power query that will show how many collective days a hardscape crew and softscape crew were at each job in the calendar. Can someone help me with this? Please see the attached worksheet I am working on. I need a table to show the job names in the worksheet B3:Q280. The names of the construction crew foremen in the header are not important. The power query needs to look something like this:
| Job Name | Hardscape Crew Days | Softscape Crew Days |
| Stevens | 2 | 4 |
| Johnson | 3 | 1 |
| Smith |
Rex-Delson Sorry for the misunderstanding. Still not sure I understand what you mean but perhaps it's the 2nd version of the table I created. If not, please give an example using the data the is in the file.
9 Replies
Rex-Delson Perhaps like in the attached file?
- Thank you for responding, but the names of the foremen are not important. I need column A in your table to list all the jobs in the worksheet range of B3:Q280. This is the difficult part for me. Do you know how to do this?
Rex-Delson Sorry for the misunderstanding. Still not sure I understand what you mean but perhaps it's the 2nd version of the table I created. If not, please give an example using the data the is in the file.
