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? Not
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
Here is a start that will get you a dataframe. You will have to
decide how you want to convert the long to wide format since that did
not clearly come through in the mail:
> x <- readLines('/tempxx.txt')
> # remove blank lines
> x <- x[x != ""]
> # create matrix
> y <- matrix(x[-(1:6)], ncol=6, b
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
4 matches
Mail list logo
