topic Double Excel-header in QlikView https://community.qlik.com/t5/QlikView/Double-Excel-header/m-p/280691#M710270 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've got a problem with my data source (Excelsheet). I cannot manage the table format into a straight QV design.</P><P></P><P>I tried to take the Name of the "User" instead of the header into each data row, until the next User (same Excelsheet) follows. Here is an example of what it looks like:</P><P></P><P><IMG alt="screenshot.png" class="jive-image-thumbnail jive-image" height="151" onclick="" src="https://community.qlik.com/legacyfs/online/5860_screenshot.png" width="644" /></P><P>In QV table it should look like this:</P><P></P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type...</P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type..</P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type...</P><P>User2&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; Ende&nbsp;&nbsp;&nbsp;&nbsp; Typ...</P><P></P><P></P><P>Has anybody an idea? Thanks a lot!</P><P></P><P>Ingo</P></BODY></HTML> Thu, 14 Jul 2011 11:19:36 GMT 2011-07-14T11:19:36Z Double Excel-header https://community.qlik.com/t5/QlikView/Double-Excel-header/m-p/280691#M710270 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I've got a problem with my data source (Excelsheet). I cannot manage the table format into a straight QV design.</P><P></P><P>I tried to take the Name of the "User" instead of the header into each data row, until the next User (same Excelsheet) follows. Here is an example of what it looks like:</P><P></P><P><IMG alt="screenshot.png" class="jive-image-thumbnail jive-image" height="151" onclick="" src="https://community.qlik.com/legacyfs/online/5860_screenshot.png" width="644" /></P><P>In QV table it should look like this:</P><P></P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type...</P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type..</P><P>User1&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; End&nbsp;&nbsp;&nbsp;&nbsp; Type...</P><P>User2&nbsp;&nbsp;&nbsp;&nbsp; Start&nbsp;&nbsp;&nbsp;&nbsp; Ende&nbsp;&nbsp;&nbsp;&nbsp; Typ...</P><P></P><P></P><P>Has anybody an idea? Thanks a lot!</P><P></P><P>Ingo</P></BODY></HTML> Thu, 14 Jul 2011 11:19:36 GMT https://community.qlik.com/t5/QlikView/Double-Excel-header/m-p/280691#M710270 2011-07-14T11:19:36Z