Help past tranpose

  • Thread starter Thread starter chennai
  • Start date Start date
C

chennai

Hi

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

Thanks
Boopathi
 
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?
 
I have numeric data from cells A1 - G50,
I need to paste the values in single column
Click to expand...

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
---
 
Back
Top