Need HELP ! Rows to Columns ? - Qlik Community

markticoy · ‎2014-11-30

Good Day Mates !

I'm sorry if I am using a wrong title for this thread, but I'll explain what my question is all about.

I have a data, source is excel. My problem is that my fields are displayed or arrange in a row. see the picture for reference

Now what I want is, convert this rows to columns. My desired result will be shown below.

Now, is there a way to achieve this kind of result ?

SunilChauhan · ‎2014-11-30

change table to pivot to straight

or drag column from horizontal to vertical in pivot table it self

hope this helps

Sunil Chauhan

sujeetsingh · ‎2014-11-30

Follow this, you need to use Generic load

markticoy · ‎2014-12-01

Thank you mates for ideas. I'll be studying your suggestions tonight.

rajeshvaswani77 · ‎2014-12-01

Hi,

Change to Pivot table and left click and drag the column to the header till you see a blue arrow pointing.

Un-click here and let it drop. The transpose would have happened.

thanks,

Rajesh Vaswani