Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.