Professor Excel

Comments 2

  1. Shozib Javaid

    Sir, Thanks for sharing useful information. I have a question could you please help me.?
    The formula which I am using is =IF(MOD(ROW()-1,4)=0,( TRANSPOSE(A4149:A4151) ),””) , just one thing more, If you please help, The rows which are to be copied in to columns are mostly hyperlinks, but when I applied this formula, it worked perfectly (converted rows to columns with desired interval) but did not copy the hyperlinks as well. How can I tackle this I want hyperlinks to be transposed also.
    Waiting for your response.

  2. Bill Ritzel

    I have a chart pointing to a horizintal row of cells which are linked to a vertical column on another sheet. Each horizontal cell contains the same thing, something like =TRANSPOSE(‘Monthly Data’!$W$3:$W$15)
    I can’t seem to find a combination in the paste special menu to both link and transform the data. Any ideas would be appreciated Thanks in advance.

Leave a comment

%d bloggers like this: