Hi,
I don't know exactly how to describe the problem. I search the forum and I cannot find a similar scenario which I believe is because I was not able to phrase my keyword properly. Here is the problem.
I have a lot of data in rows and columns. The rows are representing individual data grouped into teams. The members are listed first, then at the last row of each group the leader is listed. What I want to do is add a last column that will extract the names of the members (column C) and list them in the row of the leader. For instance, rows 2, 3 and 4 are members and row 5 is the leader. This status (being Leader or Member) is shown in column I. What I want to accomplish is list the names of members found in column C to column I. It should be listed in the leader's row.
I attached a screenshot.
Thank you for helping.
I don't know exactly how to describe the problem. I search the forum and I cannot find a similar scenario which I believe is because I was not able to phrase my keyword properly. Here is the problem.
I have a lot of data in rows and columns. The rows are representing individual data grouped into teams. The members are listed first, then at the last row of each group the leader is listed. What I want to do is add a last column that will extract the names of the members (column C) and list them in the row of the leader. For instance, rows 2, 3 and 4 are members and row 5 is the leader. This status (being Leader or Member) is shown in column I. What I want to accomplish is list the names of members found in column C to column I. It should be listed in the leader's row.
I attached a screenshot.
Thank you for helping.