Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.