Forum Discussion
Rex-Delson
Apr 05, 2023Copper Contributor
Power Query: Organizing cells into columns
Using power query, how can I organize all the data in a sheet into columns by data. For example, in the screenshot shown, I need to have all the "Orange 1" in one column by date, all the "Yellow 1" i...
Rex-Delson
Apr 08, 2023Copper Contributor
Thanks, but I need it to look like the attached pic (I manually cut/pasted to make it look like what I need it to look like). All jobs are in there own columns according to the dates, and they are alphabetical. The header with names of crews are not important. As more jobs get added to the Schedule 2023 sheet, it should also reflect in the PQ . Lorenzo
Lorenzo
Apr 19, 2023Silver Contributor
You're welcome...