On Oct 16, 7:16 am, Jennifer Andrews <Jennifer
wrote:
Where the OID are all the same, each of those streets need to
be placed in a seperate street column, instead of all being under
ST_NAME. Leigh cv, Mays Ln, and Stoneridge should occupy
ST_NAME, STREET_2, and STREET_3 all in the same row.
I'm not sure how to set up functions for this.

I am not sure I understand the assumptions you can make and the result
that you want, but I wonder if the following helps.

Assume ST_NAME, OID, STREET_2, STREET_3 and STREET_4 are columns A, B,
C, D and E, and assume "Leigh cv" is in row 2. Insert the following
formulas and copy them down their columns:

C2: if(and(B1<B2,B2=B3), A3, "")
D2: if(and(B1<B2,B2=B4), A4, "")
E2: if(and(B1<B2,B2=B5), A5, "")

Thus, in the first row with a new OID, STREET_2, STREET_3 and STREET_4
will contain up to the next 3 adjacent street names with the same
OID. Those columns will remain blank in the non-first rows with the
same OID.


----- complete original posting -----

On Oct 16, 7:16 am, Jennifer Andrews <Jennifer
wrote:
I have a street database that contains 9 columns. Not all of them will be
used on each record. Here's my problem. I have a column named ST_NAME and a
column named OID that have all my information in them. It's set up like this:
ST_NAME OID STREET_2 STREET_3 STREET_4
Leigh cv 22
Mays ln 22
Stoneridge 22
Russell 54
Makala 54

Where the OID are all the same, each of those streets need to be placed in a
seperate street column, instead of all being under ST_NAME. Leigh cv, Mays
Ln, and Stoneridge should occupy ST_NAME, STREET_2, and STREET_3 all in the
same row. I'm not sure how to set up functions for this.