Create new rows based on a region

[Syndicate_Admin]

Hello everyone.

I have a table that shows a list of video games, along with different sales columns depending on the region.

where:

Ventas NA = NorthAmerica

VentasEU = Europe

VentasJP = Japan

Sales Other = Other places

It turns out I want to split each row in the table this way

For example the video game 1942, which has sales in NA, EU and JP, is separated into 3, where it shows the region where it was sold and how much I sell in that place.

I attach an example of what I'm looking for

Thank you for your time.

[Syndicate_Admin]

Thank you very much, I served

[AllisonKennedy · Accepted solution]

@Syndicate_Admin @marfernandezj 

You can acheive this by using the unpivot columns option in Power Query. From your first screenshot, click Home > Transform Data

Then find the correct table in Power Query that you want to transform.

Select the Ventas NA column, hold the Shift key on your keyboard, then Select the Ventas Global column. 

In the Transform tab in the ribbon, click Unpivot columns. 

That should give you what you're looking for. Then click Close & Apply.

Let us know if any other questions.

Thanks!