• Thanks for the response

    If its a straight move to two tables i can do wht u mentioned.

    But the data into table2 need to be split for various cities and states for each ID