Eliminate unused columns

I have a table of columns of data per week, which I convert to a table of
columns of data per month. This leaves 3 or 4 blank columns between the
months. Is there a simple way to consolidate the month columns into a
contiguous region, eliminating the unused columns between the month columns?

Or... is there a smarter way to do the conversion than sum across an fill
down?
.

Relevant Pages

  • Re: what makes it true?
    ... mathematical theorem: if Goldbach's conjecture ... greater than 2 is the sum of two primes. ... Prev by Date: ...
    (sci.math)
  • Re: Creating a sum of different units
    ... You could put the conversion code in the After Update event of the units control. ... Anothr option could be used to select liquid or mass measures, and change the unit selection accordingly. ... All this assumes that you have one bottle per record, if this is not the case, you'll have to do this differently, but the concept is the same. ... I'd rather not ask the user to convert since my thought is that this should be a relatively easy thing to do in VBA - perhaps a case statement using a variable that would sum the values. ...
    (microsoft.public.access.formscoding)
  • Merging 2 tables
    ... I realize this is somewhat backwards from "good practice", ... make conversion into another system easier. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: more on converting strings to numbers....
    ... sum = sum + currentIntValue; ... >I have to do a little app that adds up all nos. ... >> a single element within the array. ... >> the conversion result to the sum just after the conversion ...
    (comp.lang.java.help)
  • Re: VLookup returns #VALUE!
    ... which interferes with =SUM ... > I'm stuck. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)