Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Changing table values to headers

Hi,

 

I have a set of data that looks like the below;

ConfirmationIdAnswers.Questions.QuestionNameAnswers.TextAnswer
330478BOOKING REQUEST DATE17.01.20
330478CANDIDATE EMAIL (NC)[email protected]
330478INVOICE TO mandatoryCANDIDATE TO POD
330478COST CODENA
330478etc....etc.....

 

I want the data to look like this below;

ConfirmationIdBOOKING REQUEST DATECANDIDATE EMAIL (NC)INVOICE TO mandatoryCOST CODEetc....
33047817.01.20[email protected]CANDIDATE TO POD

NA

etc....

 

I need this to work for as many column names that are listed in the first table (which is more than what I've shown).

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Fortunately for you, this will still work, even on text 🙂

     

    Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.

     

    Tadaaa 🙂

     

    Jaap

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the quick reply.  I did try to pivot the column but I don't have numbers in the values column it is text data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Fortunately for you, this will still work, even on text 🙂

         

        Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.

         

        Tadaaa 🙂

         

        Jaap