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

"Jul" wrote:

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