Forum Discussion
Move columns into one column
in Table view, I have a table with columns of different tasks types, tasks due date and name assigned to task. the data source is an excel spreadsheet. eg of layout. Name Task 1 Tas...
Ashish_Mathur hoping this is clearer ..
orginal data source layout in Excel.
Total of 13 different tasks columns/fields
| Name | Task 1 | Task 1 dueDate | Task 2 | Task 2 DueDate | Task 3 | Task 3 DueDate | Task 13 | Task 13 DueDate | Department | Team | Category 1 | Category 2 | comments |
| A | Task 1 | 17/05/2024 | Task 2 | 21/07/2024 | Task 3 | N/A | Task 13 | 20/08/2024 | HR | Recruitment | |||
| B | Task 1 | 24/07/2024 | Task 2 | N/A | Task 3 | N/A | Task 13 | N/A | Finance | Accounts | |||
| C | Task 1 | 3/06/2024 | Task 2 | 4/09/2024 | Task 3 | 15/09/2024 | Task 13 | 11/11/2024 | Marketing | Socials team | working on project B. date to complete Aug 2024 |
the requirements for the powerbi report, all tasks to be in 1 column to allow filter etc
| Staff name | All Tasks | TaskDueDate | Department | Team | Category 1 | Category 2 | comments |
| A | Task 1 | 17/05/2024 | HR | Recruitment | |||
| A | Task 2 | 21/07/2024 | HR | Recruitment | |||
| A | Task 3 | N/A | HR | Recruitment | |||
| A | Task 13 | 20/08/2024 | HR | Recruitment | |||
| B | Task 1 | 24/07/2024 | Finance | Accounts | |||
| B | Task 2 | N/A | Finance | Accounts | |||
| B | Task 3 | N/A | Finance | Accounts | |||
| B | Task 13 | N/A | Finance | Accounts | |||
| C | Task 1 | 3/06/2024 | Marketing | Socials team | working on project B. date to complete Aug 2024 | ||
| C | Task 2 | 4/09/2024 | Marketing | Socials team | working on project B. date to complete Aug 2024 | ||
| C | Task 3 | 15/09/2024 | Marketing | Socials team | working on project B. date to complete Aug 2024 | ||
| C | Task 13 | 11/11/2024 | Marketing | Socials team | working on project B. date to complete Aug 2024 |
also attached as screenshots as not all data fitted into the table in this post
orginal data source layout
power bi report requirement
how can this be achieved?
I thought Advanced Power Query - Unpivot Columns with Multiple Headers, would solve the problem?
tia
Hi,
The M code i shared with you earlier should work fine.