From Rows to column

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
 
A

aidey

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.
 
G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top