I have an existing Pivot Table of Sales Data. Item ID is a filter, but not visible in my table. I have a separate workbook with Item ID, Class A, Class B. I want to "unpivot" VLOOKUP to get Class A & Class B columns into Table Data (by Item ID), and then recreate the Pivot Table.
Solved by M. J. in 15 mins
I need help with a project. This project require pivot tables and Vlookup. I need help creating pivot table bring up a skip % performance against reader. Vlookup is also needed but I am not sure how in this case. Can you help me?