I have worksheet #2 containing a table where all cells, including row and
column headings, contain links to values in worksheet #1 in the workbook. I
want to "transpose" the table in #2 (including row and column headings) into
a table in worksheet #3, so that the rows in #2 become columns on #3 and the
columns in #2 become rows in #3, while maintaining the links to values in #1.
How do I do this.
I need a command functionally equivalent to
copy/paste special values/transpose/link
but in paste special values I can choose either transpose or link, but not
both.
Bill