• To reiterate my example:

    NAME1

    ADD1

    CITY1

    STATE1

    ZIP1

    NAME2

    CITY2

    STATE2

    ZIP2

    NAME3

    ADD3

    STATE3

    ZIP3

    For this given example i want the rows in the output to show like this:

    NAME1

    ADD1

    CITY1

    STATE1

    ZIP1

    NAME2

    CITY2

    STATE2

    ZIP2

    NAME3

    ADD3

    STATE3

    ZIP3

    Thanks!