So I want to extract data from a large data set using pivot. But i only want to extract specific data that contains specific word, can i do it with Pivot Table?
Let's say the large data set has 5column. i want to extract all the 5 columns, but only data contains word "SUP" and "C" in column A. Can i do it with PIVOT or is there other alternatives?
Don’t have an account yet? Register yourself now and be a part of our community!