Manipulating Data

  • Thread starter Thread starter BOB
  • Start date Start date
B

BOB

Is there a way to easily move text like this

Jan 1
Feb 2
Mar 3
Apr 4
may 5
june 6

to

Jan 1 mar 3 may 5
feb 2 apr 4 june 6
 
Hi Bob
on your taget sheet enter the following formula in A1:
=OFFSET('sourse_sheet'!$A$1,ROW+COLUMN()*2-3,0)
copy this down and to the right
After this, select the result cells, copy them and insert them with
'paste - special' as values

Frank
 
Frank Kabel said:
Hi Bob
on your taget sheet enter the following formula in A1:
=OFFSET('sourse_sheet'!$A$1,ROW+COLUMN()*2-3,0)
copy this down and to the right
After this, select the result cells, copy them and insert them with
'paste - special' as values

Frank
Click to expand...

Or just copy the original data, select the top left cell of the target area
,whether it is on another sheet or another book, and *Paste Special* having
selected *Transpose*

HTH

Sandy
 
Sandy said:
Or just copy the original data, select the top left cell of the
target area ,whether it is on another sheet or another book, and
*Paste Special* having selected *Transpose*

HTH

Sandy
Click to expand...

Hi Sandy
I don't think this will work for the OP's specific requirements as he
wants only every SECOND row transposed.
so in the new row 1 he wants row 1, 3, 5, ..
in row 2: 2, 4, 6, etc

For this specific scenario 'Paste Special' won't do (IMHO)

Frank
 
Hi Sandy
I don't think this will work for the OP's specific requirements as he
wants only every SECOND row transposed.
so in the new row 1 he wants row 1, 3, 5, ..
in row 2: 2, 4, 6, etc

For this specific scenario 'Paste Special' won't do (IMHO)

Frank
Click to expand...

Sorry Frank,

I never read the OP's post properly.

I was wondering why no one had suggested Transposing

Regards

Sandy
 
Back
Top