Add rows based on columns

[dgdgdg122db]

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 

[camargos88]

Hi @dgdgdg122db ,

Check this file: Download PBIX 

I assumed the column "customer_ids/22" is like "customer_ids/22/region" like the others.

If no, let me know.

[Greg_Deckler · Accepted solution]

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