Forum Discussion
Move columns into one column
The example provided was a simple table with 3 columns/fields.
The real data has 13 different tasks/colmuns.
The data in task columns contains either the data, or NA. formatted as text field.
+ additional fields to display alongside the one column are
worker, All tasks, due date, department, team, category 1, category 2, and comments
There is a total of 116 records.
If I manually merge all tasks in 1 column, total records are 1508.
I select all 13 task columns, Unpivot selected columns.
The results
mnay rows are created however mostly blank rows.
Only 2 records display. I checked the orginial data source. These 2 records are the only records with date in ALL the task columns.
The other blank rows, the records in tasks columns contain either a date or N/A
How can I achieve this?
Update --- I found the following which may solve the problem ..
Unpivot Cross Tabulated Data with Multiple Headers and Columns
https://www.youtube.com/watch?v=O2d5Ec10E1E
Advanced Power Query - Unpivot Columns with Multiple Headers
https://www.youtube.com/watch?v=y39LFLLbvk0
TIA