I have a column that has information in each row that I need 1 of 3 things done with. The issue I am running into is the data contained within column differs from row to row. Here is an example set of the data:

Row 1: 1000 · Business Checking
Row 2: 1500 · Fixed Assets:1550 Building
Row 3: 6000 · Facility Expense:6030 · Depreciation Expense
Row 4: 9520 Rental Income
Row 5: Retained Earnings

As stated previously, I would like 1 of 3 things to happen - data moved into column b, c or deleted. For examplefirst set of quotes would be column b (always a number), second set, column c)

Row 1: "1000" "Business Checking"
Row 2: "1550" "Building"
Row 3: "6030" "Depreciation Expense"
Row 4: "9520" "Rental Income"
Row 5: "" "Retained Earnings"

Is this possible?

Thanks!