tag:blogger.com,1999:blog-5407582063684028993.post6618352242331419265..comments2014-04-15T14:59:47.458-07:00Comments on MS Excel - Tips & Tricks: Transpose the MatrixRoshanhttp://www.blogger.com/profile/11631654177502024526noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5407582063684028993.post-84087963562259237952014-03-13T02:37:40.388-07:002014-03-13T02:37:40.388-07:00Thats cool, although the use is (from my point of ...Thats cool, although the use is (from my point of view) a little limited. But i guess i will need it one day, so im happy i hopefully know how to do it. I just have one question: What happens with data that refers to transposed cell, lets say via a VLOOKUP function? (for those of who who dont know what i mean by that here is a link to an overview: <a title="http://www.excel-aid.com/excel-matrix-the-vlookup-and-hlookup-functions.html" href="http://www.excel-aid.com/excel-matrix-the-vlookup-and-hlookup-functions.html" rel="nofollow">http://www.excel-aid.com/excel-matrix-the-vlookup-and-hlookup-functions.html</a> ). With "transpose" i guess it will get screwed up, but if i use special paste, will it recognize the change and the VLOOKUP function accordingly? (in theory, it could be changed to a HLOOKUP function, possibly maintaning the correct refernce). I would really be interested in a solutioen for this, as the only workaround would be to change the references manually, which would be a pian to do.Anonymoushttps://www.blogger.com/profile/06942373323877792932noreply@blogger.comtag:blogger.com,1999:blog-5407582063684028993.post-90008125701144174552013-10-17T04:14:00.852-07:002013-10-17T04:14:00.852-07:00super... thanks :)super... thanks :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5407582063684028993.post-18881672978651061432012-07-03T13:01:40.172-07:002012-07-03T13:01:40.172-07:00Great explanation. ThanksGreat explanation. ThanksAnonymousnoreply@blogger.com