Prev: Making a Excel file Read Only
Next: worksheet skipped in page numbering
From: Mr. R Mr. on 12 Jan 2010 14:01
I have multiple columns :

1 2 3 4
1 2 3 4
1 2 3 4
....

And I want to paste into a single row:
1 2 3 4 1 2 3 4 1 2 3 4.....

Transpose does not do it. Any suggestions?

Thanks
From: Dave Peterson on 12 Jan 2010 14:49
Always 4 rows by 4 columns becoming 1 row by 16 columns?



Mr. R wrote:
>
> I have multiple columns :
>
> 1 2 3 4
> 1 2 3 4
> 1 2 3 4
> ...
>
> And I want to paste into a single row:
> 1 2 3 4 1 2 3 4 1 2 3 4.....
>
> Transpose does not do it. Any suggestions?
>
> Thanks

--

Dave Peterson
From: Mr. R on 12 Jan 2010 18:26


"Dave Peterson" wrote:

> Always 4 rows by 4 columns becoming 1 row by 16 columns?
>
>
>
> Mr. R wrote:
> >
> > I have multiple columns :
> >
> > 1 2 3 4
> > 1 2 3 4
> > 1 2 3 4
> > ...
> >
> > And I want to paste into a single row:
> > 1 2 3 4 1 2 3 4 1 2 3 4.....
> >
> > Transpose does not do it. Any suggestions?
> >
> > Thanks
>
> --
>
> Dave Peterson
> .
> In my particular case, I have 4 columns and say 20 rows in some cases and 4 cols and 'n' rows. Which ever the number of rows, I would like to have one row and 4 x n columns.

Thanks Dave.
From: Dave Peterson on 12 Jan 2010 18:32
How do you determine the number of rows per group?

Is there an empty row between groups?

Is there some key indicator on the first row of a group?



Mr. R wrote:
>
> "Dave Peterson" wrote:
>
> > Always 4 rows by 4 columns becoming 1 row by 16 columns?
> >
> >
> >
> > Mr. R wrote:
> > >
> > > I have multiple columns :
> > >
> > > 1 2 3 4
> > > 1 2 3 4
> > > 1 2 3 4
> > > ...
> > >
> > > And I want to paste into a single row:
> > > 1 2 3 4 1 2 3 4 1 2 3 4.....
> > >
> > > Transpose does not do it. Any suggestions?
> > >
> > > Thanks
> >
> > --
> >
> > Dave Peterson
> > .
> > In my particular case, I have 4 columns and say 20 rows in some cases and 4 cols and 'n' rows. Which ever the number of rows, I would like to have one row and 4 x n columns.
>
> Thanks Dave.

--

Dave Peterson
 | 
Pages: 1
Prev: Making a Excel file Read Only
Next: worksheet skipped in page numbering