8 Replies Latest reply on Jan 19, 2016 2:06 PM by margaret.tanutama

    Pivot Table

    margaret.tanutama

      Original data source layout:

      NameWeek 1
      Week 2Week 3
      Jane216512700
      Sheryl414733445
      Mike563680712

       

      When I try to pivot it, the layout is as follows:

      Name
      Jane

      216

      512

      700

      Sheryl

      414

      733

      445

      Mike

      563

      680

      712

       

      How do I manipulate the data source or how to correctly pivot the data source so it looks like the following layout?

      NameWeek 1
      Week 2Week 3
      Jane216512700
      Sheryl414733445
      Mike563680712