topic Re: How am i able to use the first column values as column headers? in QlikView https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053765#M928355 <HTML><HEAD></HEAD><BODY><P>Is this issue being resolved? You have assumed answered selected which makes me think that the issue might have been resolved?</P></BODY></HTML> Fri, 01 Apr 2016 20:49:57 GMT sunny_talwar 2016-04-01T20:49:57Z How am i able to use the first column values as column headers? https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053763#M928353 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>My raw excel data format is as per below</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="438"><TBODY><TR><TD class="xl65" height="20" width="110">Eval No.</TD><TD class="xl65" style="border-left: none;" width="82">Evaluation 1</TD><TD class="xl65" style="border-left: none;" width="82">Evaluation 2</TD><TD class="xl65" style="border-left: none;" width="82">Evaluation 3</TD><TD class="xl65" style="border-left: none;" width="82">Evaluation 4</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Evaluator Name:</TD><TD class="xl65" style="border-top: none; border-left: none;">W</TD><TD class="xl65" style="border-top: none; border-left: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">Y</TD><TD class="xl65" style="border-top: none; border-left: none;">Z</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Staff Name:</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Score</TD><TD class="xl65" style="border-top: none; border-left: none;">70</TD><TD class="xl65" style="border-top: none; border-left: none;">80</TD><TD class="xl65" style="border-top: none; border-left: none;">90</TD><TD class="xl65" style="border-top: none; border-left: none;">100</TD></TR></TBODY></TABLE><P></P><P>What i want is the <SPAN style="text-decoration: underline;">first column values to become the column headers</SPAN>, and the <SPAN style="text-decoration: underline;">remaining column data to become the row data</SPAN></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 384px;"><TBODY><TR><TD class="xl65" height="20" width="110">Eval No.</TD><TD class="xl65" style="border-left: none;" width="110">Evaluator Name:</TD><TD class="xl65" style="border-left: none;" width="82">Staff Name:</TD><TD class="xl65" style="border-left: none;" width="82">Score</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Evaluation 1</TD><TD class="xl65" style="border-top: none; border-left: none;">W</TD><TD class="xl65" style="border-top: none; border-left: none;">A</TD><TD class="xl65" style="border-top: none; border-left: none;">70</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Evaluation 2</TD><TD class="xl65" style="border-top: none; border-left: none;">X</TD><TD class="xl65" style="border-top: none; border-left: none;">B</TD><TD class="xl65" style="border-top: none; border-left: none;">80</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Evaluation 3</TD><TD class="xl65" style="border-top: none; border-left: none;">Y</TD><TD class="xl65" style="border-top: none; border-left: none;">C</TD><TD class="xl65" style="border-top: none; border-left: none;">90</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Evaluation 4</TD><TD class="xl65" style="border-top: none; border-left: none;">Z</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">100</TD></TR></TBODY></TABLE><P></P><P>I would like to know how i can do this without tampering with the raw excel data format. Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053763#M928353 2020-11-25T16:16:04Z Re: How am i able to use the first column values as column headers? https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053764#M928354 <HTML><HEAD></HEAD><BODY><P>chk dis ur's</P><P><A href="https://community.qlik.com/thread/210614">Can i use the first column values as column headers?</A></P></BODY></HTML> Wed, 23 Mar 2016 09:41:36 GMT https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053764#M928354 Chanty4u 2016-03-23T09:41:36Z Re: How am i able to use the first column values as column headers? https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053765#M928355 <HTML><HEAD></HEAD><BODY><P>Is this issue being resolved? You have assumed answered selected which makes me think that the issue might have been resolved?</P></BODY></HTML> Fri, 01 Apr 2016 20:49:57 GMT https://community.qlik.com/t5/QlikView/How-am-i-able-to-use-the-first-column-values-as-column-headers/m-p/1053765#M928355 sunny_talwar 2016-04-01T20:49:57Z