split col into mutiple cols

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jack (Jack_at_discussions.microsoft.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 14:05:05 -0800

I have single col with 9000+ entries. What I am looking for is a formla that
will look similar to this: B1=a1 &","& a2 (combining the two with comma). I
have no problem with this but I am needing the formula to split this into
cols of no more than 300 rows. So ending result will be col B, Col C, etc. -
300 rows each from data in A1 Any ideas how I can get this done? I don't want
to spend day cutting and pasting.. :) Please help.

Relevant Pages

  • Re: split col into mutiple cols
    ... In cell B2 put the following formula ... > I have single col with 9000+ entries. ... What I am looking for is a formla ... > have no problem with this but I am needing the formula to split this into ...
    (microsoft.public.excel)
  • Cronological sequence formula
    ... I'm needing a formula that will number my entries ... greasybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7923 ...
    (microsoft.public.excel.misc)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... maxarray = zeros; ...
    (comp.soft-sys.matlab)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... did you really bother to try michael hosea's nice solution... ...
    (comp.soft-sys.matlab)
  • Re: max value every N entries... how to
    ... entries... ... I was wrong about only needing to swap the 24 and ... Just transpose to get the column vector. ... Mike ...
    (comp.soft-sys.matlab)