Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PO | Count | Total At Required Version | O-1 | Not At Level | Total Virtual | Total Dedicated | Other | Undetermined |
FAA | 1300 | 232 | 116 | 988 | 900 | 302 | 98 | 0 |
PO Version | Count | At Level | Not At Level | O-1 | O-1 | Unknown | ||
8000 | 100 | |||||||
8100 | 1188 | 200 | 988 | 101 | 949 | |||
8150 | 186 | 14 | 172 | 9 | 9 | |||
8300 | 47 | |||||||
VAA2.3.3 | 1234ABD_EFGG |
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.