Forum Discussion

JeroniJamboni's avatar
JeroniJamboni
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Combine columns from same table

Hi Guys,   I have a table with the following information: ID; A; B; C 1; A; B; C 2; A; B; C 3; A; B; C I want to turn these into the following table: 1; A 1; B 1; C 2; A 2; B 2; C A...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    hI JeroniJamboni

     

    In the Query Editor,, Select the Letter Columns>>>Go to Transform Tab>>> Unpivot

     

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    JeroniJamboni

     

    You will get below. Delete extraneous columns and rename as necessary

     

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

hI JeroniJamboni

 

In the Query Editor,, Select the Letter Columns>>>Go to Transform Tab>>> Unpivot

 

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    JeroniJamboni

     

    You will get below. Delete extraneous columns and rename as necessary

     

  • JeroniJamboni's avatar
    JeroniJamboni
    Icon for Advocate I rankAdvocate I
    8 years ago

    Awesome! Works like a charm! 
    Thank you!