Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to append multiple columns in one column

Hi,   I am trying to append multiple columns in one. My data looks something like below:   scorer 1 scorer 2 scorer 3 scorer 4 Di Stefano Rial Marquitos Rial Di Stefano Gento   ...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    Highlight all columns:


    Then press unpivot:


    Then you can just remove the blanks! 

    Br,

    J

tex628's avatar
tex628
Community Champion
6 years ago

Highlight all columns:


Then press unpivot:


Then you can just remove the blanks! 

Br,

J

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks tex628 for such a quick response. Much appreciated and it worked like a charm!