Forum Discussion

RanzieJ's avatar
RanzieJ
Copper Contributor
Aug 11, 2022
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 ...
excel
  • Lorenzo's avatar
    Lorenzo
    Aug 11, 2022

    Hi RanzieJ 

     

    https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d with Power Query:

RanzieJ's avatar
RanzieJ
Copper Contributor
Aug 11, 2022
Woahh, i think this is too advance. Can you teach me step by step, please? 😞
sivakumarrj's avatar
sivakumarrj
Brass Contributor
Aug 11, 2022

RanzieJ 

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

 

 

Resources