Data from columns to rows (Gantt)

[Roland74]

To create a ganttchart i need categorized data. In my model (ca. 6.000 rows) i've got all data in columns:

For the gantt i (think i) need the data to be in rows, like:

Is there an easy way to create this? 

[Roland74 · Accepted solution]

Hi Pankaj,

Thanx for your solution, but that won't work because i don't get the 'label' column and all the dates are in one column in stead of start- and enddate next to each other. 

My current 'work-around':

* Duplicate the table several times;

* Delete datecolumns in each table, i have 3 tables: 

    - Project // Start 1 // End 1

    - Project // Start 2 // End 2

    - Project // Start 3 // End 3

* Rename the columns, so they are identical;

* In each table, add a custom label column with fixed text, e.a. Task1, Task 2, etc.

* Append the tables

This works, but my live-table has got many more tasks with dates. i hope there is an easier way to do this.

[pankajnamekar25]

Hello @Roland74 

use Power Query

Unpivot the Task Columns

Select the Project column.

Go to the ribbon: Transform → Unpivot Other Columns.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.