Help past tranpose

[chennai]

Hi

I have numeric datas from cells A1 - G50 ,I need to paste the values in
single column ,

Thanks
Boopathi

 

[Gary''s Student]

Which way?

Say we are coping from the table into single column H, we can have:

H1 contains A1
H2 contains A2
....

or

H1 contains A1
H2 contains B1
....

Which way do you want?

 

[Max]

I have numeric data from cells A1 - G50,

I need to paste the values in single column

One way to strip any rectangular source range into a column range elsewhere
Assume source data in Sheet1's A1:G50
In another sheet,
Place this in any start cell, say in B2:
=OFFSET(Sheet1!$A$1,INT((ROWS($1:1)-1)/7),MOD(ROWS($1:1)-1,7))
Copy B2 down as far as required, ie by 350 rows
(A1:G50 contains 50R x 7C cells = 350)

Adapt to suit:
a. "Sheet1!$A$1" - OFFSET's anchor, the top left cell in the source range
b. "7" in both INT & MOD - change to suit the cols # in the source
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---