You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

numbers pivot table

Hello,

I tried pivot table in numbers and Fields are showing up as Column A, Column B, Column C etc rather than the field name. This makes the job really difficult as I need to go through the main sheet to identify which each column represents. Any idea how can I see the field name / heading in the field to select instead of Column A, B, C etc.

MacBook Air 13″, macOS 12.6

Posted on Oct 2, 2023 7:48 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 2, 2023 12:14 PM

Numbers shows Column A, Column B, etc. because your columns don't have headers. Yes you have put titles but they are in a "normal" row.


Select your table and in the Format sidebar, section Table, sub section Headers and Footers, give one Header row to your table.



It might also be useful to set one header column.



BTW you don't have to post two messages to include pictures, you can mix text and picture in the same post.

8 replies
Question marked as Top-ranking reply

Oct 2, 2023 12:14 PM in response to umar167

Numbers shows Column A, Column B, etc. because your columns don't have headers. Yes you have put titles but they are in a "normal" row.


Select your table and in the Format sidebar, section Table, sub section Headers and Footers, give one Header row to your table.



It might also be useful to set one header column.



BTW you don't have to post two messages to include pictures, you can mix text and picture in the same post.

Jun 29, 2024 4:53 AM in response to umar167

Hello,

I tried pivot table in numbers and Fields are showing up as Column A, Column B, Column C etc rather than the field name. This makes the job really difficult as I need to go through the main sheet to identify which each column represents. Any idea how can I see the field name / heading in the field to select instead of Column A, B, C etc.

can u show above steps in video.


numbers pivot table

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.