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.
