er sorry... people often use PERL for this. python too i think but i meant to say perl :P perl is a lot like php if wondering. anyhow yeah... still curious about where your data is coming from and what format its coming in as (: On Wed, May 12, 2010 at 4:01 PM, Alan Wolfe <alan.wolfe@xxxxxxxxx> wrote: > I could be wrong but i think that in excel you can't make something that > removes values from columns. > > are you trying to use excel to convert data from one format to a different > format? > > If so, people use python for this quite a bit, but you could also bust out > some of your c++ if you wanted. > > If my assumptions are correct so far... where are you getting your source > data and what format is your source data in? (ie is it a csv file or what?) > > > On Wed, May 12, 2010 at 3:54 PM, Nick Klotz <roracsenshi@xxxxxxxxx> wrote: > >> sorry, look at the PNG image instead >> >> >> all the formatting got messed up >> > >