Home

Table Headers

%3CLINGO-SUB%20id%3D%22lingo-sub-325015%22%20slang%3D%22en-US%22%3ETable%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325015%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20table%20that%20has%20information%20I%20need%20to%20capture%20each%20week%20for%2013%20weeks.%20%26nbsp%3BSo%2C%20under%20each%20week%2C%20there%20are%203%20cells%20(Appointments%20Set%2C%20Appointments%20Run%2C%20Enrollments%20Set).%20%26nbsp%3BWhen%20I%20make%20these%203%20cells%20repeat%20across%20the%20table%20as%20headings%20under%20each%20week%2C%20Excel%20adds%20a%202%2C%20then%203%2C%20etc.%20%26nbsp%3BUnder%20week%201%2C%20the%203%20cells%20are%26nbsp%3BAppointments%20Set%2C%20Appointments%20Run%2C%20Enrollments%20Set%20and%20then%20Under%20Week%202%2C%20they%20auto%20correct%20to%20Appointments%20Set2%2C%20Appointments%20Run2%2C%20Enrollments%20Set2%2C%20then%20under%20Week%203%2C%20it%20adds%20a%203.%20%26nbsp%3BHow%20do%20I%20turn%20that%20function%20off%3F%20%26nbsp%3BIs%20it%20possible%3F%20%26nbsp%3BI%20want%20each%20Week%20to%20say%20the%20same%203%20headings.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-325015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325389%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325389%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethe%20issue%20is%20that%20you%20are%20trying%20to%20enter%20data%20into%20a%20report%20layout.%20That%20is%20never%20a%20good%20idea.%20Instead%2C%20create%20a%20flat%20table%20with%20columns%20for%20Week%2C%20Type%20and%20value.%20In%20the%20type%20column%2C%20enter%20either%20Appointments%20set%2C%20Appointments%20run%20or%20Enrollments%20Set%20and%20in%20the%20value%20column%20enter%20what%20the%20data%20is%20for%20that%20week%20and%20type%20combination.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20data%20entry%20table%20does%20not%20have%20to%20look%20pretty%2C%20it%20just%20needs%20to%20be%20functional.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20you%20can%20build%20a%20pivot%20table%20where%20your%20data%20is%20grouped%20by%20week%20and%20type.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F70892i088CF7EC7D21FC48%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-01-25_16-20-49.png%22%20title%3D%222019-01-25_16-20-49.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20is%20a%20very%20simplified%20example.%20You%20may%20have%20more%20fields%20in%20the%20table%2C%20which%20can%20be%20used%20to%20add%20rows%20to%20the%20pivot%20table.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325216%22%20slang%3D%22en-US%22%3ERe%3A%20Table%20Headers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325216%22%20slang%3D%22en-US%22%3E%3CP%3ETable%20doesn't%20allow%20duplication%20of%20column%20headers%2C%20they%20are%20to%20be%20different%2C%20You%20may%20use%20sequential%20tables%20or%20convert%20table%20to%20range%2C%20perhaps%20some%20other%20workaround.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
robaflac
Occasional Visitor

I created a table that has information I need to capture each week for 13 weeks.  So, under each week, there are 3 cells (Appointments Set, Appointments Run, Enrollments Set).  When I make these 3 cells repeat across the table as headings under each week, Excel adds a 2, then 3, etc.  Under week 1, the 3 cells are Appointments Set, Appointments Run, Enrollments Set and then Under Week 2, they auto correct to Appointments Set2, Appointments Run2, Enrollments Set2, then under Week 3, it adds a 3.  How do I turn that function off?  Is it possible?  I want each Week to say the same 3 headings.

2 Replies

Table doesn't allow duplication of column headers, they are to be different, You may use sequential tables or convert table to range, perhaps some other workaround. 

Hello,

 

the issue is that you are trying to enter data into a report layout. That is never a good idea. Instead, create a flat table with columns for Week, Type and value. In the type column, enter either Appointments set, Appointments run or Enrollments Set and in the value column enter what the data is for that week and type combination. 

 

The data entry table does not have to look pretty, it just needs to be functional.

 

Now you can build a pivot table where your data is grouped by week and type. 

 

2019-01-25_16-20-49.png

 

This is a very simplified example. You may have more fields in the table, which can be used to add rows to the pivot table. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies