Forum Discussion
thebeginner1204
4 years agoHelper I
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...
- 4 years ago
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
- 4 years ago
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! 😊
amitchandak
4 years agoSuper 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