Man, there’s nothing I can do that makes my table look like that. For some reason, once I make “Phone” my Row Label, all my entries become column headers… and the various instructions I see on the web show the same result.
So instead of getting column headers like “Phone”, “Name”, “Address” I get “Phone”, “John Smith”, “Mary Smith”, “Cecil Adams”, “Jane Adams”, etc… Actually, “Phone” doesn’t even appear as a column header.
Everything should be row headers. All the other fields (value, columns, filters) should be blank. Phones goes on top, and then last name, and then first name. Then you should see them all grouped in sort of an outline form. In the PivotTable toolbar up top, you can then change the display to “Tabular” mode to have it more horizontal and less outline-y.
If that doesn’t make sense, try posting your file somewhere so we can take a look.