Hi Chaya,
You no need to cut and paste the each cells. Simply u just copy the data
which u need to be in row. then right click-paste special-values (and
select transpose). Now you data will be pasted in single row.
Note the same method u can use to copy the data in single column if it is
in
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question - is there a way to split it up into several rows (for example
5 rows, with 3 columns per row)?
On Monday, August 19, 2013 6:21:59 PM UTC-4, Prabhu Pinky wrote:
Hi Chaya,
You no need to cut and paste the each cells.
you mean same data in each row..?.. or can you share me your file with
requirement..?
like below..
[image: Inline images 1]
Thanks Regards,
Prabhu R
On 20 August 2013 04:02, Chaya Cooper chayacoo...@gmail.com wrote:
That's amazing :-D I'm sorry I waited this long to ask ;-)
One question
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper chayacoo...@gmail.com wrote:
Unfortunately, the data in each row is different
I've attached an image with an example :-)
On Mon, Aug 19, 2013 at 6:36 PM,
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
hi chaya,
hope if u share the file.. it will be so fine to work.
Thanks Regards,
Prabhu R
On 20 August 2013 04:35, Chaya Cooper chaya...@gmail.com
Am just asking you to share the excel file.
On 20-Aug-2013 5:50 AM, Chaya Cooper chayacoo...@gmail.com wrote:
I'm sorry, I'm not sure I understand what you're saying :-(
On Monday, August 19, 2013 7:24:56 PM UTC-4, Prabhu Pinky wrote:
hi chaya,
hope if u share the file.. it will be so fine
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar prashant...@gmail.comwrote:
Hi Chaya, Prabhu,
Done with a simple macro.
Use Control + Shift + A at particular cell where you want to transpose.
This you have to to for every entry.
In case you
Ashish,
That's exactly what I needed :-D
Would you mind showing me how to use it?
- Chaya
On Tuesday, August 20, 2013 12:50:23 AM UTC-4, ashish wrote:
Hi try the attachment . see if it helps
On Tue, Aug 20, 2013 at 9:46 AM, Prashant Pednekar
prash...@gmail.comjavascript:
wrote:
=OFFSET('Sample - Unedited'!$A$1,COLUMN('Sample -
Edited'!A1)+(COUNTA($A$1:$C$1)*(ROW(A1)-1)),0)
'Sample - Unedited'!$A$1 - header of source column
COLUMN('Sample - Edited'!A1) - will give us 1 , 2 , 3
(COUNTA($A$1:$C$1)*(ROW(A1)-1)) will give us 0 , 3, 6
'
0 because source data is in same
Dear Chaya
The solution from Ashish (using offset command) has lesser effort than
using macro. I suggest to use the same for your multiple entries.
using macro is possible in 2008 . no issue. For your information. you have
to use Ctrl+ shift + A at first column of each row required.
Regards
10 matches
Mail list logo
