This script works…when the table has rows. But this table is occasionally cleared out. Due to the nature of this program, Table1 sometime has no entries at all.

To split data into rows using Power Query, you need to follow these steps: Let us assume that our data consists of a string of text with delimiters (names and email addresses separated by a ...