[AccessD] 8 columns of data to 6 output fields

Sorry Chris but the list is text only. You can't paste tables in.

GK

On Tue, Nov 16, 2010 at 3:19 PM, Chris Swann <dc8 at btinternet.com> wrote:
> Hi again,
>
> This is some of the data that I have to work with. As mentioned
> previously, not all the columns contain data. The first two columns are
> the "odd" ones that need processing first.
>
>                ADZ     LARC    CONU
>
> LARC            01A
>                CONFDIS         01A     LARC    02B
>
>                CONFDIS         02B     01A
> LARC            CONFDIS         02B     01A
> LARC
> 6       4       27A
> 23
> 9       7       LARC
> LARC
> 9
>                CONFDIS         01A     01C     LARC
>
>
> LARC            02B     01A
>                CONFDIS         01A     02A     09C
>                27B     ECSC
> LARC            09B     01B
>
>

-- 
Gary Kjos
garykjos at gmail.com