Convert columns into rows while importing from excel??

[#1]

Hello,

I have some data in excel as following

Project     Profit     Jan     Feb     March

abc          234        x        x

xyz          3213      x                    x

.........

.........

........

Now when i want to import this data into qlikview, I want these months to be in one single column so that i can show trend bases on these months. I dont want each month to appear as a seperate column in Qlikview

Can someone suggest how can i convert these months as a single dimension  in the load script

Arif

[its_anandrjs]

Hi,

When ever you load data in cross table like CrossTable(Months, Value, 2) here 2 denotes after seconde column you want to make cross table suppose if you have 3 rows and 4 columns so your data loads becomes 12 and loaded 12 times your dable and here Months means ffrom which column in excel you want cross table and Values means it loaded all resting of same data in the column named Values.

As you say you want data in some middle so use to load data conditionally by using where clause.

Rgds

Anand

[SunilChauhan]

its depend upon u from where u want to make cross table.

but if you have data of same type then you can make cross table from starting.

other wise there is no other way.