How can I get my data after doing a paste special transpose from looking like
this:

A B C D
1 1 1 1
2 2 2 2
3 3 3 3

To look like this:

A
1
2
3

B
1
2
3

C
1
2
3

D
1
2
3

Any help would be much appreciated.

Thanks, Mark