I am trying to add a text column in my pivot table. I want to add the UNIT column text to go with all of my values. (For example: |Clear and Grub| LUMP SUM|). If that is not possible, then Id like to add a column where I can VLOOKUP my UNIT column. I have multiple VLOOKUP columns in my spreadsheet, but am having trouble with adding a UNIT column VLOOKUP.
In my example, on the pivot table worksheet, I want Column C to be the UNIT Text column. For the VLOOKUP, it would have to be inserted into Column A.
Bookmarks