bdietz
asked on
Excel copy/paste and transpose question
Hi
I have a 20x20 grid of values, but i will make it 2x2 for simplicity, something like:
1 2
3 4
i can paste special to get something like:
1
2
but i want to be able to highlight all four values and just paste them like:
1
2
3
4
and obviously do this for my larger 20x20 block. can i do this in excel?
I have a 20x20 grid of values, but i will make it 2x2 for simplicity, something like:
1 2
3 4
i can paste special to get something like:
1
2
but i want to be able to highlight all four values and just paste them like:
1
2
3
4
and obviously do this for my larger 20x20 block. can i do this in excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade!
Brad