Duplicate cell contents problem

[AFZAL SOHAIL]

I have a excel file as shown in the image I the contents of col B,C and D manually copied the downside, I need a formula which is do it automatically please
e.g

1	10066582	Muhammad Nawaz	Executive network Ops.	03.03.2024	05.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				10.03.2024	12.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				17.03.2024	19.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				24.03.2024	26.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				31.03.2024	02.04.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
2	19930362	Syed Asad Ali	Senior technician	03.03.2024	06.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				10.03.2024	13.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				17.03.2024	20.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR
				24.03.2024	27.03.2024	Fiber Ops-IV LTR S LH	Fixed & WL A/N Ops LTR

 

[awoohaw]

I'm guessing you want to fill in the blanks with the cells above? So copy A1:D1 to A2:D5?
If so, it would not be a formula.
Highlight the Range from A2 to the bottom of your data in column D.
Click F5,
Click Special Cells
Click the "Blanks"
Click OK
(at this point do not click anywhere in the worksheet!)
then just type = and use the up arrow key or type "=A1" (in this instance).
then CNTL-ENTR.

(If you want to convert to the text values, just copy paste over itself as values)

 

[arthurbr]

The easiest way I think is using Power Query which is available in your versions ( it's also called " Get and Transform")
Just add this code in the Advanced PQ editor. If you add more rows a simple refresh should do

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"Column2", "Column3", "Column4"})
in
    #"Filled Down"

 

[AFZAL SOHAIL]

Thanks a lot Sir,
I tried it is working very well, if more trick then share also please

 

[awoohaw]

Thanks a lot Sir,
I tried it is working very well, if more trick then share also please

which post did you use?

 

[AFZAL SOHAIL]

Post#2 is find well.
Post#3 I check but the editor was giving error

 

[AFZAL SOHAIL]

Post#3 giving the following error

 

[Peter_SSs]

@arthurbr
On a side issue - perhaps you could review your signature since the "latest" XL2BB version info is not in fact the latest version. I guess if you use XL2BB yourself that means an update of that might be in order too.

 

[arthurbr]

@arthurbr
On a side issue - perhaps you could review your signature since the "latest" XL2BB version info is not in fact the latest version. I guess if you use XL2BB yourself that means an update of that might be in order too.

Thanks for the heads-up, Peter

 

[AFZAL SOHAIL]

Kindly need solution for the error in Post#3