How do I automate the Updated Memo line to populate with corresponding values from multiple columns?

[jlawrence]

I was trying to use PowerQuery but I kept getting Expression.SyntaxError when making if statements. Is there an easier way to automate this without making separate lookups to each column? It is a very large file with about 3000 lines. Thanks!

An example of the columns: account name, company, memo, update memo

Account Name Company Memo Update Memo
1000:Supplies Office Supplies
2000:Travel Travel, Training
Wireless Wireless Svcs
Staples Office Supplies
1000:Supplies
1000:Supplies
2000:Travel
Staples
Wireless
Licenses Licenses
Licenses