I have this source data:
Contact Name (Q3_1) | Contact Email (Q2_1) | Country of Entity (Q5) | Country Company 1 | Country Company 2 | Country Company 3 | Country Company 4 | Country Company 5 |
Name 1 | Email 1 | Country A | XYZ | ||||
Name 2 | Email 2 | Country B | ABC | ||||
Name 3 | Email 3 | Country C | ABC2 | ||||
Name 4 | Email 4 | Country C | XYZ2 |
Is there a way I can transpose it to look like this? where the country Company matches the Country.
Contact Name (Q3_1) | Name 1 | Contact Name (Q3_1) | Name 2 | Contact Name (Q3_1) | Name 3 | Contact Name (Q3_1) | Name 4 |
Contact Email (Q2_1) | Email 1 | Contact Email (Q2_1) | Email 2 | Contact Email (Q2_1) | Email 3 | Contact Email (Q2_1) | Email 4 |
Country of Entity (Q5) | Country A | Country of Entity (Q5) | Country B | Country of Entity (Q5) | Country C | Country of Entity (Q5) | Country C |
Country Company 4 | XYZ | Country Company 2 | ABC | Country Company 3 | ABC2 | Country Company 3 | XYZ2 |