How to convert similarity ratings data into matrix?

Dear all,

I've collected similarity data on the 7-point Likert scale for a range of items (e.g., A, B, C), where participants were rating all possible combinations of these items. The results have the following format:

A, A, 7

A, B, 4

A, C, 2

B, A, 3

B, B, 7

B, C, 5

C, A, 2

C, B, 6

C, C, 7

As you can see, rating of items in reverse order (e.g., AB and BA) is not always the same.

Is there a way I can transform the data table (item1, item2, rating) into similarity matrix (like the one below)?

A, B, C

A, 7, 4, 2

B, 3, 7, 5

C, 2, 6, 7

[Parth Dethaliya]

The data you collected is in which format? Can you share a sample data in the format you have!

[Dinesh Yadav]

As parth mentioned can you tell how you have stored data and in which format? It would be easier to answer you question that way.

[Magdalena Kachlicka]

Somehow I completely missed these responses, sorry! I'm not quite sure what you mean by the data format? The data is a simple table of values from 1-8, as indicated above (also see the attached file for example). In the end, I've used the R function called cast() to do this, but I wonder if there is anything working in a similar way for Matlab too?