Aug 10 2022 07:04 PM
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 one.
Thank You!
Aug 10 2022 07:26 PM - edited Aug 10 2022 07:27 PM
@RanzieJ You need VBA coding to cut/move data. Give a try on below sub. Assuming you Credit Account column is B. You have to adjust Range("B2:B200") for you real case.
Sub MoveData()
Dim rng As Range
For Each rng In Range("B2:B200")
If rng <> "" Then
rng.Offset(, -1) = rng
rng.Clear
End If
Next rng
End Sub
Aug 10 2022 07:42 PM
SolutionAug 10 2022 09:06 PM
Aug 10 2022 10:27 PM
This isn't advanced at all but pretty classic Power Query transformation
#1 Format your data formatted as Table:
#2 Go to Data (tab) > From Table/Range (Power Query editor opens)
#3 Go to Transform tab
#4 Select columns [DEBIT ACCOUNT] & [CREDIT ACCOUNT] > Merge Columns
#5 By default the new column name is "Merged". Change this with i.e. DEBIT/CREDIT ACCOUNT > OK
#6 File > Close & Load
Aug 10 2022 11:22 PM - edited Aug 10 2022 11:30 PM
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
Aug 10 2022 11:25 PM
Hi there.
Filter the credit account and choose the range like this:
Then fill them left like that:
Aug 17 2022 07:40 PM
Aug 10 2022 07:42 PM
Solution