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