Forum Discussion

dgdgdg122db's avatar
dgdgdg122db
Helper II
6 years ago
Solved

Add rows based on columns

Hi,

I have a table looks like this:

There are 6 extra columns indicating different customer IDs and locations under the same user.

What I would like to achieve is to spit these 6 columns in to three rows, like this:

Please help 

  • Not sure because you refer to 3 but also to 6 but unpivot your last 3 columns.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    Not sure because you refer to 3 but also to 6 but unpivot your last 3 columns.