Hi, team . i need soulution for the following issue . please help me out .

[vnktalteryx]

 need the values of mass 100 to next empty rows and mass value 90 to next empty row. 

how to resolve the issue with out using multi row formula tool?

please help me in resolving the issue!

V_c	year	c_c	mass
M1	2020	eu28	100
M1	2021	eu28
M1	2021	uk
M1	2022	uk
N1	2020	eu28	90
N1	2021	uk

[binuacs · Accepted solution]

@vnktalteryx Multi-row is the best option, another way of doing this with the join tool

[MilindG · Accepted solution]

[BS_THE_ANALYST]

@binuacs nice!