Hi,
I want to move a field into a column at each change in [condition]. For each person in my data set, I want to put each of their memberships for the year in a new column. Basically, each person has a single row, even if they have multiple memberships. Each membership would become a new column instead of a new row, but the other data pertinent to the persons record would only output once.
Ex:
[Column 1] [Column 2] [Column 3] [Column 4]
John Smith Phone Membership 1 Membership 2
I want to move a field into a column at each change in [condition]. For each person in my data set, I want to put each of their memberships for the year in a new column. Basically, each person has a single row, even if they have multiple memberships. Each membership would become a new column instead of a new row, but the other data pertinent to the persons record would only output once.
Ex:
[Column 1] [Column 2] [Column 3] [Column 4]
John Smith Phone Membership 1 Membership 2