Results 1 to 1 of 1
  1. #1
    Join Date
    May 2012
    Posts
    1

    Red face Unanswered: Modification into "dyadic compositions"

    Dear friends,

    I am struggling with the data management for my thesis.
    Could you help me?

    I like to modify the table 1 into table 2.
    "from the rows of each group into the rows on the basis of dyadic ties that compose each group"

    I think some formula such as excel macro is required, but I am not sure...
    Thank you so much in advance!



    -----------------------------------------------------
    Table 1

    id name Group participant# Group id
    1 Horse ---------3 --------1
    2 Rabbit---------3 --------1
    3 Tiger----------3 --------1
    4 Mouse---------2 --------2
    5 Ox-------------2 --------2
    6 Cat------------4 --------3
    7 Zebra ---------4 --------3
    8 Eagle ---------4 --------3
    9 Panther-------4 --------3

    -------------------------------------------------------
    Table 2

    id name Group participant# Group id
    1 Horse----------- 2----------- 1
    2 Rabbit---------- 2----------- 1
    1 Horse----------- 2----------- 1
    3 Tiger------------ 2----------- 1
    2 Rabbit----------- 2----------- 1
    3 Tiger------------ 2----------- 1
    4 Mouse----------- 2----------- 2
    5 Ox----------------2----------- 2
    6 Cat---------------2----------- 3
    7 Zebra------------ 2----------- 3
    6 Cat---------------2----------- 3
    8 Eagle-------------2----------- 3
    6 Cat---------------2----------- 3
    9 Panther ----------2----------- 3
    7 Zebra------------2----------- 3
    8 Eagle------------ 2------------ 3
    7 Zebra------------ 2------------ 3
    9 Panther----------2------------ 3
    8 Eagle------------ 2------------ 3
    9 Panther ----------2------------ 3
    Last edited by sangy; 05-15-12 at 14:36.

Tags for this Thread

Posting Permissions

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