6 Replies Latest reply: Sep 1, 2016 7:04 AM by Vishnu A RSS

    How can I convert columns into rows while loading the data

    Shazad Nazir

       

      Hi Experts,

       

      I have an excel file like this 

       

       

       

      Product

      Name

      Birmingham

      London

      Borth

      Telford

      C0001

      Chemical 01

      100

      90

      20

      120

      C0002

      Chemical 02

      25

      75

      25

      80

       

       

       

      I want it in this way:

       

      Product

      Name

      City

      Qty

      C0001

      Chemical 01

      Birmingham

      100

      C0001

      Chemical 01

      London

      90

      C0001

      Chemical 01

      Borth

      20

      C0001

      Chemical 01

      Telford

      120

      C0002

      Chemical 02

      Birmingham

      25

      C0002

      Chemical 02

      London

      75

      C0002

      Chemical 02

      Borth

      25

      C0002

      Chemical 02

      Telford

      80

       

      Can somebody please guide!