One Click Method for Filling the Data in the Below Cells With the Same on Top

[anifnisar]

Dear Forum, can i get help regarding this Excel Sheet i can use Drag and Drop but i need to do that one by one for all these people for example the amount mention in Gross 4 times belongs to the same person on Top and i can do it by drag and drop and fill it one by one is there a Method to do it in one Go
Thanks And Regards

 

[hagia_sofia]

Hello, you could e.g. select the whole table, hit F5, then select Special > Blanks and hit OK. Next type = and then hit the arrow up and then CTRL + ENTER.

 

[anifnisar]

Hello, you could e.g. select the whole table, hit F5, then select Special > Blanks and hit OK. Next type = and then hit the arrow up and then CTRL + ENTER.

Thanks In Tons
Any Shortcut ?

 

[hagia_sofia]

I am not aware of any. Maybe just a formula to do the same:

=LET(
r,A1:C10,
DROP(REDUCE("",SEQUENCE(COLUMNS(r)),LAMBDA(x,y,HSTACK(x,SCAN("",CHOOSECOLS(r,y),LAMBDA(a,b,IF(b<>"",b,a)))))),,1))