Forum Discussion

MMadni's avatar
MMadni
Copper Contributor
Feb 02, 2020

Data Drop Down with Constent Break

Dear All I have query regarding data drop down, in my sheet I have 38K lines, and around 4000 material name but with break of multiples of line.   Like one material name come in 1st row and 20 row...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 02, 2020

MMadni 

If this is a one-time operation you could enter in C1:

=B1

Then in C2, enter:

=IF(ISBLANK(B2),C1,B2)

 and copy it all the way down. See attached for an example.

Once you are satisfied with the end result, you can Copy column C and Paste as Values in B and then delete column C.

Resources