Let say I have a table that looks this:
State--City TX--Houston TX--Dallas OK--Stillwater
And I want to insert it into a table that looks like this:
For results that look like this:
State--City1--City2--City3 TX--Houston--Dallas--Null OK--Stillwater--Null--Null
Should I use a search cursor to build a list then use that list to populate the 'insertRow'?