我有以下格式的数据导出:
Address 1 | Person 1 | Status
Address 1 | Person 2 | Status
Address 1 | Person 3 | Status
Address 2 | Person 1 | Status
Address 3 | Person 1 | Status
Address 3 | Person 2 | Status
我试图把它变成一份报告,其中的地址用于对人员及其状态进行分组:
| Address 1 |
| Person 1 | Status |
| Person 2 | Status |
| Person 3 | Status |
| Address 2 |
| Person 1 | Status |
| Address 3 |
| Person 1 | Status |
| Person 2 | Status |
我尝试使用数据透视表创建此格式,但没有成功。任何帮助都将不胜感激!
谢谢