8 Replies Latest reply: Nov 6, 2012 5:14 AM by bhupeshg RSS

    How to Split single Column value in Mutiple Columns to generate Pivot chart

      Hi

       

      We have a requirment where we need to divide a single Excel coulmn into mutiple columns while fetching data in qvd so that we can generate a pivot chart out of it

       

      The data looks like

       

      ObjectDescriptionActual AmountBudgetAvailableCommited
      1NW0001XYZ100010222
      A11101test200012365
      WBS01test300044354
      WBS02Test52223544
      WBS03test464645354
      A11102test354454345
      WBS04test132134535
      WBS05test789933257

       

      and it should look like

       

      Object Object1Object 2Header 4Header 5Header 6
      1NW0001
      1NW0001A11101
      1NW0001A11101WBS01
      1NW0001A11101WBS02
      1NW0001A11101WBS03
      1NW0001A11102
      1NW0001A11102WBS04
      1NW0001A11102WBS05