Forum Discussion
Need Help Transforming Pivoted Data
Hi Anonymous ,
For your requirement, I'm afraid that we should use Append Queries in Query Editor.
Here is my test data sample which is similar to yours.
CustomerFirst Name 1Last Name 1Title 1Phone 1Email 1First Name 2Last Name 2Title 2Phone 2Email 2
Customer A A1 1A A 1231456 1231456@ A2 2A AA 456789 456789@ Customer B B1 1B B 789456 789456@ B2 2B BB 741852 741852@ You could duplicate the table and then remove the columns Name 1Last Name 1Title 1Phone 1Email 1 in Table 2 and remove Name 2Last Name 2Title 2Phone 2Email 2 in Table 2 and rename the column name.
Then Append table 1 and table 2.
More detail steps, please refer to my attachment.
Best Regards,
Cherry
Hi Anonymous ,
For your requirement, I'm afraid that we should use Append Queries in Query Editor.
Here is my test data sample which is similar to yours.
CustomerFirst Name 1Last Name 1Title 1Phone 1Email 1First Name 2Last Name 2Title 2Phone 2Email 2
| Customer A | A1 | 1A | A | 1231456 | 1231456@ | A2 | 2A | AA | 456789 | 456789@ |
| Customer B | B1 | 1B | B | 789456 | 789456@ | B2 | 2B | BB | 741852 | 741852@ |
You could duplicate the table and then remove the columns Name 1Last Name 1Title 1Phone 1Email 1 in Table 2 and remove Name 2Last Name 2Title 2Phone 2Email 2 in Table 2 and rename the column name.
Then Append table 1 and table 2.
More detail steps, please refer to my attachment.
Best Regards,
Cherry
Cherry,
This is exactly what I was looking for! I got tunnel vision on the "pivot/unpivot" columns that I missed such a simple and easy solution. Thanks so much for your help!
All the best,
Chris