How To Convert Column Data Fields To Row Data Fields

Sometimes you have columns doing double duty as a data. This video shows how to convert or move a column field into a row data field using the consolidated range option in the pivot table wizard.