transpose rows to columns per ID

[geroagostini]

Hi team! This might be more a question related to data modeling...

I have a pivot table as te picture shows (with a lot of data and more than 2 courses) -> I would need to have only one row per ID.

Is there any way to reach a table with just one row per ID in Power Bi or Excel?

[amitchandak]

@geroagostini , in power bi once you import data you can use fill down. The same is there in Excel too

Power Query - Fill Up Fill Down: https://youtu.be/mC2ps0pFqBI

[geroagostini]

Hi @amitchandak

I'm not trying to do that.

I need only one row per ID.

The row would be for example for the first ID:

62810 - example course 14 - example course 14 - example course 621