lygismav

convert table that has many records per parcel to a table that has a single record

Discussion created by lygismav on Jun 7, 2012
Latest reply on Jun 8, 2012 by lygismav
Hello,

I have a table that has one or more lines in for each parcel depending on how long the legal description is.  I would like to change it so that there is only one line for each parcel, and several lines for the legal description.

Currently the table looks like this

Parcel             Record       Legal
02-0002-901       1             NW1/4SE1/4 LESS W 500 FT, SW1/4NE1/4 LESS W 5
02-0002-901       2             00 FT OF S 753 FT & N1/2NE1/4 LESS L.P. BIG S
02-0002-901       3             TONE LAKE-WHETSTONE RIVER PROJECT

I would like to change it so that it looks like this

Parcel             Record       Legal Line 1                                                                                Legal Line 2                                                       Legal Line 3
02-0002-901       1             NW1/4SE1/4 LESS W 500 FT, SW1/4NE1/4 LESS W 5    00 FT OF S 753 FT & N1/2NE1/4 LESS L.P. BIG S      TONE LAKE-WHETSTONE RIVER PROJECT

Any ideas on how to do this via model builder?>

Outcomes