Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
Not applicable

Poorly Formatted Excel Document - Need to split into Two Tables

So I am having an issue with some data. Basically it comes into a format I really do not enjoy and was looking to see if there was a way that I could either format this into a two tables instead of one. The Red Text is supposed to be the headers for each table. I'd like to be able to have the first two lines as Table 1 and the rest as table 2 Minus the last line. The report comes this way and I don't have the ability/access to edit the format of how it is generated.  

POCountTotal At Required VersionO-1Not At LevelTotal VirtualTotal DedicatedOtherUndetermined
FAA1300232116988900

302

980
PO VersionCountAt LevelNot At LevelO-1O-1Unknown
8000100
81001188200988101949
81501861417299
830047
VAA2.3.31234ABD_EFGG
1 Reply
Not applicable

Re: Poorly Formatted Excel Document - Need to split into Two Tables

Por los momentos dos ideas. Haces una macro personal en Excel que realice el formateo que requieres. O con macro de qlikview generas el Excel tal y como lo quieres.