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.
Is there any way to reach a table with just one row per ID in Power Bi or Excel?
2 Replies
- amitchandak
Super User
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
geroagostiniHi 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
