How do I get column titles to show up in my pivot table?

nrcahill · #1 03-02-2016, 12:14 PM

Pivot table newbie here. I have a spreadsheet with four columns, which I turned into a table in order to create a pivot table. When I select the column names (fields) from the table to include in the pivot table, the associated data just stacks up vertically, without any column headings. How can I get the pivot table to show my data horizontally, under the same column headings that are in my spreadsheet table? Thanks for any help.

gebobs · #2 03-03-2016, 07:29 AM

Please attach your sheet.

nrcahill · #3 03-03-2016, 12:28 PM

See my little test spreadsheet attached. Thanks.

gebobs · #4 03-07-2016, 09:35 AM

I can't tell what you want to do. The data table from which you are making the pivot does not appear to have data headers, just more data in the first row.

Furthermore, all of your data, aside from some dates, is text. Pivot tables are useful tools for summarizing and performing operations on grouped data which I just don't see here.

What exactly do you want to do?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show percentage of results in a Pivot table	rogelinepaula	Excel	0	11-22-2015 06:58 PM
Create PIVOT chart using few rows in pivot table	Santhosh_84	Excel	1	08-31-2015 06:22 AM
Want a quotient using a constant to show up in column c each time a number is added to column b	fibbermcghee	Excel	2	12-09-2014 05:48 PM
Pivot table with numbers as column headers	kezhia_0128	Excel	0	08-28-2014 12:48 PM
Show part codes only whose have Book qty bal.in Pivot table	PRADEEPB270	Excel	2	02-15-2012 04:09 AM