I would like to be able to copy a block of cells, and in paste special I need
to be able to transpose and paste link. When I check transpose, I cannot
click paste link. I know a pivot table will do this. Is there an easier way?