Pivot table with two columns on the left

[QlikSensor]

Hi, we are used to ît from Excel: Having two columns on the left before the Pivot table starts.

There is a 1:1 relationship between two columns of my raw table. Let's say the first column is a unique number of a database and the second column is a unique descriptive field of that unique number. I want to show both columns right next to each other before the actual pivoting starts. I only managed in QlikSense to introduce the descriptive field as a dimension which leads to having the number field and the descriptive field below if I expand the number field (and even more worse I get two lines in the resulting pivot table).

I am wondering if it's possible to show the descriptive field right next to that number field?

[Vegar]

By using your current table you can do the pivot tables below. To the left I've combined Name and Number into one field.  

If you want to pivot the table in the script as you wrote in your example then you should look at The Generic Load community post by @hic.