Forum Discussion

Roland74's avatar
Roland74
Icon for Helper I rankHelper I
1 year ago
Solved

Data from columns to rows (Gantt)

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 ...
  • Roland74's avatar
    1 year ago

    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.