Data Cleaning

[Hiteshp]

Hello Team,

In the below data, i have couple of cells missing data under manager column, i need the output in such a way that if the row is missing data then copy the values from the cell above

Input		Output
Employee	Manager		Employee	Manager
Raj	Nimish		Raj	Nimish
Ajay			Ajay	Nimish
Aileen			Aileen	Nimish
Edgar	Hitesh		Edgar	Hitesh
Evelyn			Evelyn	Hitesh
Chinkie			Chinkie	Hitesh

[MilindG · Accepted solution]

@Hiteshp Does this work for you?

[TUSHAR050392 · Accepted solution]

Hey @Hiteshp You can use a multirow formula tool by selecting Manager column in update existing column and writing below formula -

IF ISNULL(Manager) then ROW-1:Manager ELSE Manager ENDIF

Let me know if this helps

[Hiteshp]

@MilindG  & @TUSHAR050392  the solutions helped, Appreciate your time to help me fix it