danhendo888
Board Regular
- Joined
- Jul 15, 2019
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
I have a table of data with three columns:
- company code
- company name
- sales
When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go about this? Create a new column and vlookup? Power query and merge? Is there a simpler method..
https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=unsUeJ
- company code
- company name
- sales
When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go about this? Create a new column and vlookup? Power query and merge? Is there a simpler method..
https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=unsUeJ
