Convert columns to matrix

Question

I have to convert a set of columns that contains the list of nodes connected to each other in a network. Something like this:

I need to convert this information into a grid like structure for better information presentation, like this:

Could you please help me how to achieve this?

@NEO_mental.. Can't post screenshot.. I do not have enough reputation.. — Rahul Katarey, Dec 04 '14 at 05:30

score 0 · Answer 1 · edited May 23 '17 at 11:51

0

I think what is described in detail here: Convert matrix to 3-column table ('reverse pivot', 'unpivot', 'flatten', 'normalize') should suit, together with filtering to select 0 values in the third column and deleting those.

edited May 23 '17 at 11:51

Community

answered Dec 03 '14 at 11:12

pnuts

1 Answers1