Fill a column

[Geo Jul]

Dear All​

I need to fill column C according to what is in Cell B2 and if its comes to C11 to fill according to what's in Cell B10 and so on, and the list is huge​

I need your help with a formula. sorry the number in B2 or others are without ABC This is an example ​

please note that I am using excel 2016 at work​

Many Thanks in advance​

 

[alansidman]

With Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Columns" = Table.RemoveColumns(Source,{"Column1"}),
    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Custom", each if Text.Length([Due date])>8 then [Due date] else null),
    #"Filled Down" = Table.FillDown(#"Added Custom",{"Custom"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Filled Down",{"Departure date", "Due date", "Custom", "Transaction number"})
in
    #"Reordered Columns"

 

[Geo Jul]

With Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Columns" = Table.RemoveColumns(Source,{"Column1"}),
    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Custom", each if Text.Length([Due date])>8 then [Due date] else null),
    #"Filled Down" = Table.FillDown(#"Added Custom",{"Custom"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Filled Down",{"Departure date", "Due date", "Custom", "Transaction number"})
in
    #"Reordered Columns"

many thanks on your reply but most of our Co-workers are very familiar with PowerQuery, which is why i requested an excel formula thank you for your responses.

 

[Peter_SSs]

Is this what you mean?

24 01 07.xlsm
	A	B	C
1
2	Assets	A
3	date	date	A
4	date	date	A
5	date	date	A
6	date	date	A
7	date	date	A
8	date	date	A
9	date	date	A
10	Assets	B
11	date	date	B
12	date	date	B
13	date	date	B
14	date	date	B
15	date	date	B
16	Assets	C
17	date	date	C
18	date	date	C
19	date	date	C
20	date	date	C
21	date	date	C
22	date	date	C
23	date	date	C
24	date	date	C
Fill C

Cell Formulas
Range	Formula
C2:C24	C2	=IF(A2="Assets","",IF(A1="Assets",B1,C1))

 

[Geo Jul]

Is this what you mean?

24 01 07.xlsm
	A	B	C
1
2	Assets	A
3	date	date	A
4	date	date	A
5	date	date	A
6	date	date	A
7	date	date	A
8	date	date	A
9	date	date	A
10	Assets	B
11	date	date	B
12	date	date	B
13	date	date	B
14	date	date	B
15	date	date	B
16	Assets	C
17	date	date	C
18	date	date	C
19	date	date	C
20	date	date	C
21	date	date	C
22	date	date	C
23	date	date	C
24	date	date	C
Fill C

Cell Formulas
Range	Formula
C2:C24	C2	=IF(A2="Assets","",IF(A1="Assets",B1,C1))

I very much appreciate your help and valuable time (Genius) Thank you very much

 

[Peter_SSs]

Glad it worked for you. Thanks for the follow-up.