Hi Eveyone,
I have data organised in the following way:
Title Units Customer
Title A 1 Customer 1
Title B 1 Customer 2
Title C 1 Customer 1
Title A 1 Customer 3
Title C 1 Customer 2
Title B 1 Customer 1
Title B 1 Customer 3
What I'm trying to do is sort the data so that we can show what each customer bought, so that using the (awesome) gephi software I can map the relationships between any two products. I can use pivot tables to work out who bought what but what I can't do is sort the data in the way I need to.
I need to get to the following layout:
Title Title 2 Weight
Title A Title B 2
Title A Title C 1
Title B Title C 1
this shows that 2 customers bought bought A&B, 1 bought A&C and 1 bought B&C. Its fairly easy to do manually for a few products, but a time consuming nightmare once the numbers and possible relationships increase.
What I could do with is an automated way of producing the second graph from the information in the first... any help will be greatly appreciated.
Many thanks,
Mark
Bookmarks