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 |
