How Do I Solve This Data Sorting Problem?

[awfgal]

Hi guys - thanks again for the good product....

Real quick, I was wondering if you could give some tips on helping me solve this issue.

I have a csv file with a list of info only the way it was sent to me is like this (example):

2606 Dwight Way, Berkeley, California 94704-3029


In state of the address, city, state and zip code all being in separate columns, they are in rows!

My issue is I want to upload this list to a site and have different pages for each state. This means I have to go through the data and sort by the state - simple if there was one state column, but more involved here.
Is there a way to simply solve this?

[nickmattern]

Hi guys - thanks again for the good product....

Real quick, I was wondering if you could give some tips on helping me solve this issue.

I have a csv file with a list of info only the way it was sent to me is like this (example):

2606 Dwight Way, Berkeley, California 94704-3029


In state of the address, city, state and zip code all being in separate columns, they are in rows!

My issue is I want to upload this list to a site and have different pages for each state. This means I have to go through the data and sort by the state - simple if there was one state column, but more involved here.
Is there a way to simply solve this?

I'm sure we can help you out. Email a copy of the data to nickmattern@gmail.com and after I put the boys to bed tonight, I'll take a peek at it.