Poorly Formatted Excel Document - Need to split into Two Tables

Fri, 02 Apr 2021 08:02:09 GMT

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

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

Wed, 24 May 2017 03:22:20 GMT

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.

topic Re: Poorly Formatted Excel Document - Need to split into Two Tables in Connectivity & Data Prep

Poorly Formatted Excel Document - Need to split into Two Tables

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