Forum Discussion

Helper I

4 years ago

Solved

Fill cell in column

Dear Community I am looking for a solution for formatting the data of a file which contains the personnel number in the first column. Then in column 3-4 time entries of this employee follow. The...

Need Help

rohit_singh

Solution Sage

4 years ago

Hi thebeginner1204 ,

Consider this as my sample data

Go to Transform tab in Power Query and click on Fill --> Fill down

This will give you the desired output

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊

thebeginner1204

Helper I

4 years ago

Thank you! So simple...stupid of me
must work more with Power BI 🙂