Sort out a column.

[thebigman]

I wonder if anyone has a solution to my prob. I have a list of money transactions. But instead of 2 columns with in and out they are all in one and have money in. And money out. Is it possible to separate them into separate columns without doing it one by one. Thanks for any help.

[6StringJazzer]

If they are all in one column, where does it say "money in" and "money out"?

[alansidman]

Simple answer is yes. But to give you guidance on how to do this, it is best if you upload a sample workbook that is representative of your actual file.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[thebigman]

Sorry it’s 2 column with one column of text with money in money out and another with a column of money.

[thebigman]

Something like attached but only much longer.

[JeteMc]

If I correctly understand what the desired outcome should look like, then perhaps the following will help.
The column headers 'Money in' and 'Money out' are in E1 and F1 respectively.
1. E2 is populated using: =IFERROR(INDEX($B$1:$B$5,AGGREGATE(15,6,ROW(A$1:A$5)/($A$1:$A$5=E$1),ROWS(A$1:A1))),"")
2. Drag the fill handle over to F2
3. While E2:F2 are still selected drag down to F5.
Let us know if you have any questions.

[thebigman]

Thanks have been away but away to try it out thank you.

[JeteMc]

You're Welcome and thank you for the feedback. If that resolves the issue, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.