Forum Discussion
Helper IFill 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 following example shows employee "314" from line 63 - 130.
Then follows employee "340" from line 133 - XXX. Is there a way to fill the gap with the employee number until the next number begins? Best at the moment when i transforming the data form the File.
Thanks for the tip.
thebeginner1204 , Check if Fill Down in power query can help
Fill Up, Fill Down : https://www.youtube.com/watch?v=fuH29kkK12A&list=PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki&index=5
Hi thebeginner1204 ,
Consider this as my sample dataGo 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! 😊
4 Replies
- amitchandak
Super User
thebeginner1204 , Check if Fill Down in power query can help
Fill Up, Fill Down : https://www.youtube.com/watch?v=fuH29kkK12A&list=PLPaNVDMhUXGbfdGuSsfPR1qKBRT5Ywlki&index=5
rohit_singhSolution Sage
Hi thebeginner1204 ,
Consider this as my sample dataGo 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
Thank you! So simple...stupid of me
must work more with Power BI 🙂 - thebeginner1204
Thank you! So simple...stupid of me
must work more with Power BI 🙂