Data Cleaning

Question

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 OutputEmployeeManager EmployeeManagerRajNimish RajNimishAjay  AjayNimishAileen  AileenNimishEdgarHitesh EdgarHiteshEvelyn  EvelynHiteshChinkie  ChinkieHitesh

MilindG · Accepted Answer

@Hiteshp Does this work for you?

TUSHAR050392 · Accepted Answer

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