Forum Discussion
geroagostini
Helper I
Helper Itranspose rows to columns per ID
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. ...
amitchandak
Super User
Super Usergeroagostini , 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
geroagostiniHelper I
Helper IHi 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