Yes, my apologies, I want to do this in R.
> Date: Tue, 22 Jul 2008 11:33:01 -0700> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> CC: r-help@r-project.org> Subject: Re: [R] Help with rearranging
> data> > Hi,> > is your question how you do this in R? Note that this is a
> mailing> list for R. There are probably other lists/groups better suited for>
> Excel-specific problems.> > Cheers> > Henrik> > On Tue, Jul 22, 2008 at 10:59
> AM, William Pepe <[EMAIL PROTECTED]> wrote:> >> > In Excel, I have data that
> looks like this.> >> >> >> >> >> > Month> > Seg> > Prod> > Biller> > Cycle> >
> Sales> >> > 1/1/2008> > A> > Table> > Phyllis> > 1> > 500> >> > 1/1/2008> >
> A> > Table> > Phyllis> > 2> > 600> >> > 1/1/2008> > A> > Table> > Phyllis> >
> 3> > 650> >> > 1/1/2008> > A> > Table> > Doreen> > 1> > 345> >> > 1/1/2008> >
> A> > Table> > Doreen> > 2> > 451> >> > 1/1/2008> > A> > Table> > Doreen> > 6>
> > 550> >> > 1/1/2008> > A> > Table> > Doreen> > 9> > 590> >> > 1/1/2008> > A>
> > Table> > Doreen> > 11> > 860> >> > 1/1/2008>!
> A> > Chair> > Phyllis> > 1> > 300> >> > 1/1/2008> > A> > Chair> > Phyllis>
> 2> > 350> >> > 1/1/2008> > B> > Table> > Phyllis> > 1> > 700> >> > 1/1/2008>
> B> > Table> > Phyllis> > 4> > 750> >> > 1/1/2008> > B> > Table> > Phyllis> >
7> > 650> >> > 1/1/2008> > B> > Table> > Doreen> > 1> > 800> >> > 1/1/2008> >
B> > Table> > Doreen> > 2> > 975> >> > 1/1/2008> > B> > Chair> > Phyllis> > 1>
> 400> >> > 1/1/2008> > B> > Chair> > Phyllis> > 2> > 450> >> > 1/1/2008> > B>
> Chair> > Doreen> > 3> > 560> >> > 1/1/2008> > B> > Chair> > Doreen> > 5> >
550> >> > 2/1/2008> > A> > Table> > Phyllis> > 2> > 900> >> > 2/1/2008> > A> >
Table> > Phyllis> > 3> > 950> >> > 2/1/2008> > A> > Table> > Doreen> > 1> >
780> >> > 2/1/2008> > A> > Table> > Doreen> > 2> > 800> >> > 2/1/2008> > A> >
Chair> > Phyllis> > 1> > 450> >> > 2/1/2008> > A> > Chair> > Phyllis> > 2> >
440> >> > 2/1/2008> > A> > Chair> > Doreen> > 2> > 425> >> > 2/1/2008> > A> >
Chair> > Doreen> > 3> > 390> >> > 2/1/2008> > B> > !
Table> > Phyllis> > 1> > 875> >> > 2/1/2008> > B> > Table> > Phyllis>
> 2> > 800> >> > 2/1/2008> > B> > Table> > Doreen> > 2> > 675> >> > 2/1/2008> >
> B> > Table> > Doreen> > 3> > 885> >> > 2/1/2008> > B> > Chair> > Phyllis> >
> 1> > 450> >> > 2/1/2008> > B> > Chair> > Doreen> > 2> >> > 435> >> >
> 2/1/2008> > B> > Chair> > Doreen> > 3> > 400> > I want to rearrange the data
> so that I have columns such as Seg Prod Biller Cycle Jan Sales Feb Sales A
> Table Phyllis 1 500 0 A Table Phyllis 2 600 900 A Table Phyllis 3 650 950 A
> Table Doreen 1 345 780 A Table Doreen 2 451 800 A Table Doreen 6 550 0 A
> Table Doreen 9 590 0 A Table Doreen 11 860 0and so on. Any ideas on how this
> can be done, I would be greatly appreciative. Thanks, Sonic> >
> _________________________________________________________________> >> >> >
> _WL_Refresh_messenger_video_072008> > [[alternative HTML version deleted]]>
> >> > ______________________________________________> > R-help@r-project.org
> mailing list> > https://stat.ethz.ch/mailman/listinfo/r-help> > PLEASE do
> read the posting guide!
http://www.R-project.org/posting-guide.html> > and provide commented,
minimal, self-contained, reproducible code.> >> >
______________________________________________> R-help@r-project.org mailing
list> https://stat.ethz.ch/mailman/listinfo/r-help> PLEASE do read the posting
guide http://www.R-project.org/posting-guide.html> and provide commented,
minimal, self-contained, reproducible code.
_________________________________________________________________
[[elided Hotmail spam]]
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
