Forum Discussion
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" in one column by date, and so on for all the data within C2:I67.
The actual worksheet (attached) will have data in C2:R261. As new data is entered and moved around (because the sheet is a schedule), I will need Power Query to show the existing & new future data in columns with the columns sorted alphabetically. Please advise or show this in the attached worksheet so I can see the steps. The ultimate objective is to clearly see each job in one column so we know what days each job took place. Thanks in advance.
Sheet 1
5 Replies
-Formatted your data as Table - See tab Table1
-Hidded row #1 (table Header)
-Replaced Labor Day and the like with "nothing"EDIT: A more efficient option: 2023 SCHEDULE - Coordination_2
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
You're welcome...
