+ Reply to Thread
Results 1 to 2 of 2

Transform correlation matrix into a vector-column

  1. #1
    Registered User
    Join Date
    10-19-2012
    Location
    Moscow
    MS-Off Ver
    Excel 2010
    Posts
    1

    Transform correlation matrix into a vector-column

    Hi. I have a correlation matrix in excel with the first row and the first column being the names of the variables.
    eg
    Alfa Beta Gamma
    Alfa 1 0.3 0.7

    Beta 0.3 1 0.5

    Gamma 0.7 0.5 1

    I need to transform this matrix into 3 colums, eg

    Alfa Alfa 1
    Alfa Beta 0.3
    Alfa Gamma 0.7
    .....

    I have lots of matrices like this so I need to find an easy way to do it, but my excel knowledge is quite limited.
    Can anyone help?

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Transform correlation matrix into a vector-column

    If you're ok with a macro, see attachment.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1