Transform Table

[IgorGol]

Hi,

I want to transform this table : 

https://imgur.com/6RBqu2L

to this table: 

https://imgur.com/ygsud3v

with Qlik, actually I have no clue how to start 😞

I will glad for any help

Thanks!

[Gui_Approbato]

Hi,

Apparently you just aggregated the data 'removing' the task number, right?

You can use the "Group by" clause in the script to create a new table with aggregated data.

Or just load it as is and just make it the same table aggregating the measures without this task column.

I hope it helps.

Cheers 

[IgorGol]

Thanks!

And if I want to add Date ? 

I have month names on columns , how can I transform it to dates?