Professor Excel

Comments 1

  1. Shozib Javaid

    Hi
    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.
    Thanks
    Shozib

Leave a comment