Simple. Everyday. Automation.

Word Table to Excel Columns

Word Table to Excel Columns

Client was nice enough to provide “clean” data in table form

Task: convert Word table to Excel columns

Challenges:

  • Parse Nordic Addresses
  • Combine Products from multiple rows into single cell
  • Research Addresses

Although I offered to check all of the addresses, the client only needed the bad addresses (in red) to be checked.


[ws_table id=”1″]