Re: Row Compression

If the order of your rows has to be maintained, you can insert a new column
A, fill it with a series of numbers, 1 thru n, then sort on the column with
the blanks, delete the 'bad' rows, re-sort by the column with the series in
it, and finally delete that column.

Otherwise, use Jim's suggestion


"W. Watson" <wolf_tracks@xxxxxxxxxxx> wrote in message
news:rA08e.6997$lP1.5201@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Is it possible to remove rows that are blank in some column?
>
> Suppose I have
>
> a 4
> b 6
> 8
> d 2
> e 9
>
> And want to remove rows with a blank in column 1 and collapse the whole
> array to get:
>
> a 4
> b 6
> d 2
> e 9
>
> --
> Wayne T. Watson (Watson Adventures, Prop., Nevada City, CA)
> (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
> Obz Site: 39° 15' 7" N, 121° 2' 32" W, 2700 feet
>
> "Academic disputes are vicious because so little
> is at stake." -- Anonymous
>
> Web Page: <home.earthlink.net/~mtnviews>
>


.

Relevant Pages

  • Re: Problem returning a variant containing an safearray of idispatch
    ... Thanks Brian, your suggestion does work out great. ... Now if i want to return more than 1 element in the array, ... Prev by Date: ...
    (microsoft.public.vc.atl)
  • Re: Initial investor expectations
    ... What an interesting array of answers. ... But Jerry thanks for your suggestion, ... Prev by Date: ...
    (misc.invest.stocks)
  • binary array to byte type?
    ... would like to collapse this into a byte array. ... ideas on an easy way to accomplish this? ... Prev by Date: ...
    (comp.lang.java.programmer)
  • access structure array
    ... loop. ... Any suggestion? ... but it shows only the first element, not the whole array of 10 ... Prev by Date: ...
    (comp.soft-sys.matlab)
  • Re: Dynamic array
    ... > Is it possible to have in Access an array without prespecifying its limit? ... > Thanks for any suggestion! ... Prev by Date: ...
    (microsoft.public.access.formscoding)