I have a problem here guys.
I have a worksheet that contains data from 7 different drop down lists.
One of these drop down lists is in 10 different columns. And another is in 6 different columns.
I would like to add all of them to my pivot table, to analyse the data collected from 526...