From Rows to column

  • Thread starter Thread starter Jul
  • Start date Start date
J

Jul

Hello, need some help here.
I need to change data from:

Cell Cell1 Cell2 Cell3 Cell4 Cell5 Cell6 Cell7
A A1 A2 A3 A4 A5 A6 A7
B B1 B2 B3 B4 B5 B6 B7
C C1 C2 C3 C4 C5 C6 C7
D D1 D2 D3 D4 D5 D6 D7
E E1 E2 E3 E4 E5 E6 E7

And turn them into

CELL
A A1
A A2
A A3
A A4
A A5
A A6
A A7
B B1
B B2
B B3
B B4
B B5
B B6
B B7
etc...

Thanks
 
You could copy your cells, then paste special and select transpose,
then select each column and drag underneath the first column. How many
rows are in your spreadsheet? If there are many, you may need a
macro.

Aidey.
 
for the 35 data points you have here
I assume
A is row 1
B is row 2 etc
and you have a 7x35 block of data which yoiu wish to turn into a 1x35 block
of data

go to A35 and enter
=offset(A1,mod(row(),7),floor(Row()/7,1)-4))
copy down to A69
Copy A35:A69 and paste special values over itself.
 
or if what you want is to go from a 7x5 data set to a 5x7 data set
Copy A1:E7
Select A10 and paste special transpose
 
Back
Top