Forum Discussion
Solved
EXCEL - HOW TO MOVE MULTIPLE DATA (ONLY) FROM COLUMN TO OTHER COLUMN BLANK
Good day, can i ask for help regarding my problem in excel? i want to move/cut data from "Credit account" to the left "Debit Account" . I have a hundred transactions 😞 i cant move it one by ...
Woahh, i think this is too advance. Can you teach me step by step, please? 😞
Simply select Column B & Column C,
Under Data heading Click filter button
Select Column B with Blanks
Next Select Column C with Cash or Cash in Hand
Now it will display with rows of Cash
Type formula in Cell B5 = C5(Cash)
then copy formula and then do special paste with values
after that you delete the b column