Hi,
pls help. Whenever "online" appears in the "Desc" column I need to shift the matching row down (shaded area).
for example, "online" appears in H2, hence, C2:E2 need to be shifted down to C3:E3 leaving C2:E2 blank.
Next, H3 has "online" there, C3:E3 need to be shifted down one row so the result will look like the data on the "result" tab.
Thanks in advance.
Luke
Bookmarks