Help needed with autocomplete

Hello everyone,

Please advice me (or help me) with something:

I receive daily a excel document with 3 columns:
First is Name, Second is Kind of Activity, Third one is Time expressed.
In the first column I have the name of worker, in the second I have on different rows different activites and on the third is hours...
The problem is name of worker is put only in the first row while I need to have the same name for every activity in the second column, and for every worker could be a different number of rows (a different number of activities). So my question is if I can make it automatically to autocomplete name of the worker for every row in activity, depending of how many rows are.

I attached a sample of my file

Thank you.

you either have a helper column
in d2 =if(a2<>"",a2,d2)

or use power query to fill in the gaps

Thank you for the quick answer...it's not working with the helper column.
Can you provide more with how to use power query to fill the gaps?

Thank you

Please Login or Register  to view this content.

I like the vba approach above but
=if(a2<>"",a2,d1) in d2 and copy down, you may need to change , to ; for your region

I am no powerpivot expert, so would struggle to help you there.

attached is the other solution in a workbook, just press the button