1 Reply Latest reply: May 23, 2017 11:22 PM by Enrique Gutierrez RSS

    Poorly Formatted Excel Document - Need to split into Two Tables

    Benjamin Byers

      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