How to transpose information?

[Nemo1]

Hello everyone, 

So I have data in an excel represented like this: 

but i want to have it represented like this:

how can i do that with qlik sense? 

thanks!!

[Kushal_Chawda]

@Nemo1  Create pivot table like below.

1. Add Month to Column dimension

2. Create two measures for Sales & Cost as Sum(Sales) & Sum(Cost)

3. Drag Values to Row dimension as highlighted in screenshot

[Venkat7]

use cross table in load editor

cross table 

[Venkat7]

use cross table 

[Nemo1]

that does not work 😞 

I get on top of my table this loupe , which is not what I am looking for. 

[Nemo1]

This is a better example of what I need to do. 

As input table I have this: 

The result I am aiming for is: 

I have read that i could do this with generic load but I have no idea how to do that. 

Any help is appreciated.