Hi!
So I'm working on forming a network map based on data which is constantly updated with new entries. Long story short, i'm using Excel in combination with Gephi to do this.
My problem is (refer to Attached Image) I have 4 columns (MAterial, Research,Uni, Company) all of which are linked to their own individual excel sheets. I need to combine these 4 columns into one as seen on the left. The fields in MAterial, Research etc are constantly updated (since this is an ongoing study). How can I Automatically sort these 4 column into one without having to give commands each time?.
https://postimg.org/image/eb603ulul/
thanks
Chris
So I'm working on forming a network map based on data which is constantly updated with new entries. Long story short, i'm using Excel in combination with Gephi to do this.
My problem is (refer to Attached Image) I have 4 columns (MAterial, Research,Uni, Company) all of which are linked to their own individual excel sheets. I need to combine these 4 columns into one as seen on the left. The fields in MAterial, Research etc are constantly updated (since this is an ongoing study). How can I Automatically sort these 4 column into one without having to give commands each time?.
https://postimg.org/image/eb603ulul/
thanks
Chris
