I have emails coming to my inbox on a daily basis. Starts with notification wording (approximately one or two paragraphs). Then goes table in a text format. Then goes another paragraph or two.
I connected through Microsoft Exchange to this folder. When consolidate, I need to remove all the data and hopefully can consolidate all text tables together and then split them (text to columns or column split). Tried using Power Query, not working well. Cannot do it in consistent steps.
Can anyone advise what could be other options? Thanks!
I connected through Microsoft Exchange to this folder. When consolidate, I need to remove all the data and hopefully can consolidate all text tables together and then split them (text to columns or column split). Tried using Power Query, not working well. Cannot do it in consistent steps.
Can anyone advise what could be other options? Thanks!
