topic Marco For Left alignment in excelsheet after Transpose in QlikView https://community.qlik.com/t5/QlikView/Marco-For-Left-alignment-in-excelsheet-after-Transpose/m-p/732596#M262417 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement where columns along with values should align to left.</P><P></P><P>The below example looks similar as in the excel sheet but it was not proper. So any one please help me in writing a macro after transpose of the table to get all the mentioned things in left aligned form.</P><P></P><P>Ex:Policy No&nbsp;&nbsp;&nbsp; 421</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case No&nbsp;&nbsp;&nbsp;&nbsp; 4353</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Occurrence Date 09/09/2014</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Team&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAN</P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Best Regards,</P><P>Padu</P></BODY></HTML> Thu, 30 Oct 2014 12:17:02 GMT padmanabhan_ram 2014-10-30T12:17:02Z Marco For Left alignment in excelsheet after Transpose https://community.qlik.com/t5/QlikView/Marco-For-Left-alignment-in-excelsheet-after-Transpose/m-p/732596#M262417 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement where columns along with values should align to left.</P><P></P><P>The below example looks similar as in the excel sheet but it was not proper. So any one please help me in writing a macro after transpose of the table to get all the mentioned things in left aligned form.</P><P></P><P>Ex:Policy No&nbsp;&nbsp;&nbsp; 421</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Case No&nbsp;&nbsp;&nbsp;&nbsp; 4353</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Occurrence Date 09/09/2014</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Team&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAN</P><P></P><P>Thanks in Advance</P><P></P><P></P><P>Best Regards,</P><P>Padu</P></BODY></HTML> Thu, 30 Oct 2014 12:17:02 GMT https://community.qlik.com/t5/QlikView/Marco-For-Left-alignment-in-excelsheet-after-Transpose/m-p/732596#M262417 padmanabhan_ram 2014-10-30T12:17:02Z