Merge/Concate with IF's? Or am i overthinking this?

Because of awkward and uncontrollable online formatting, I have data that has to be copy and pasted into a workbook. It (often but not always- see the case of "donation") compresses two data fields that should rightfully be split into neighboring cells (for example B2, C2) into ascending cells in the same column (for example, B2 C2).

Unless I am overthinking everything, I need the 'description' (the 'Processing fee' or 'Credit') to be in the same row as their corresponding item/transaction number. ('the xxx-yyyyyyyyyyy')

I've thought to try nested concate or jointext with Lookup Search for the paramaters of "XXX", "Fee" and "Credit", but i can't find the right formula to work.

Who's got the solution?

Many thanks!

Thanks for your input Richard. I'll upload a new workbook with additional commentary/context and try again!

Hopefully this is more helpful:

I have a set of data that I, unfortunately, have to regularly copy and paste from an online source. It produces 20 rows and 5 columns of data, as you might see with the first two rows mysteriously offset into an extra column. (seen as column A or a "bonus/work column")

While some values are rather straight forward: date, values, and ending balance, some are not. The formatting of the data, for some reason, pastes the "description" and the "code" into neighboring cells of the SAME COLUMN, as opposed to, as i'd think it convenient, neighboring cells of the SAME ROW.
By this you might see in the "original":
G5: Bag Credit
G6: FUN-0032573152
I'd think it sensible for the item description and code to be in neighboring cells of the same row, or even in the same cell altogether. (if need be)
G3 H3 G3
Bag Processing Fee FUN-0032573152 or even Bag Processing Fee FUN-0032573152


There are some transactions in which this does not occur. For example, in which the description is one line only because the transaction is a 'donation'. This has threw off some of my previous attempts of formulas that were odd/even row-based formulas.


I've uploaded a longer version of the original file, and shown an example of what an "end version" i am hoping to see. However, that end version is only produced by manual copy-paste's, as my attempts at, for example, conditional lookups based on a search of "fee" or "credit", have all failed.

Would appreciate someone's fresh perspective, as I think I've been well overthinking this, OR, entirely missing a mark!
Thanks!

So I do this for work all the time.
I get Text files that are in all sorts of weird order.
I find a common denominator and then when I copy and paste the data into a "Filter"

I then organize what I want to go into each column and what isn't allowed.

In your case Column "A" could only allow strings of text that have the word "Bag" or "Online" or "Donation" found and all other cells would be ignored.
Then since the "Code" always has a "-" in it, That was easy to parse out.

The numeric columns were harder. Excel understands dates as values 1 to "infinite" 1 being 1/1/1900 and 1/1/1901 being 366 etc.

So I picked 42000 as a good round number to separate what is monetary and what is a date.. Less than that number it is probably money, greater than that
number it is probably a date.

I then created a table lookup based on index match and removed the spaces.


This is slow, as it is very volatile (lots of calculating formulas) but it is faster than sifting through unorganized data.

If someone can do better and finds a faster way to organize the raw data, it won't hurt my feelings and I will likely learn something.
That said, Here is what I came up with.

TheNewkidd, great help. I wouldn't have thought of that supporting table. And Richard, your formula was nearer to what I had in mind, (albeit much cleaner) but couldn't spit out in any rendition. Many thanks.