Forum Discussion
Power query data from a calendar worksheet
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.
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.
Yes, that's it. I'm still learning about pivoting and power query. The steps I see you did is helping me alot. Much appreciated! Now, my last obstacle is creating columns that list the foreman associated with each job. Some jobs have multiple foremen. Please see the attached where I added some columns for foreman, but don't know how to query it.
