How to Get Simpler Table Headers?

[JenniferMurphy]

I would like to save the data from this graph in an Excel table.

But Excel keeps adding suffixes to make the headers unique.

EBikes.xlsx
	B	C	D	E	F	G	H	I	J	K
4	Bicyclist Deaths by Helmet Use
5		No Helmet		Helmeted		Unknown		Total
6	Year	#	%	#2	%2	#3	%3	#4	%4	Ratio
7	1994	776	97	19	2	1	0	796	100	48.5
8	1995	783	95	34	4	11	1	828	100	23.8
9	1996	731	96	27	4	3	0	761	100	24.0
10	1997	785	97	23	3	3	0	811	100	32.3
11	1998	741	98	16	2	0	0	757	100	49.0
Helmet v No Helmet

Cell Formulas
Range	Formula
K7:K11	K7	=[@[%]]/[@[%2]]

The best solution I could think of is to put spaces around the "duplicate" headers.

EBikes.xlsx
	B	C	D	E	F	G	H	I	J	K
4	Bicyclist Deaths by Helmet Use
5		No Helmet		Helmeted		Unknown		Total
6	Year	#	%	#	%	#	%	#	%	Ratio
7	1994	776	97	19	2	1	0	796	100	48.5
8	1995	783	95	34	4	11	1	828	100	23.8
9	1996	731	96	27	4	3	0	761	100	24.0
10	1997	785	97	23	3	3	0	811	100	32.3
11	1998	741	98	16	2	0	0	757	100	49.0
Helmet v No Helmet

Cell Formulas
Range	Formula
K7:K11	K7	=[@[%]]/[@[ % ]]

Is there a better way?

 

[SanjayGMusafir]

Try this -
For some reason over the years I don't prefer #, $ & * in header names as they can cause errors while analyzing. Also, if possible, avoid spaces in table names or header names, even with sheet names. Using small & Caps (TestExample) combination to keep them readable is my hack.

Book1
	B	C	D	E	F	G	H	I	J
4	Bicyclist Deaths by Helmet Use
5		No Helmet		Helmeted		Unknown		Total
6	Year	NoH	NoH%	H	H%	Ukwn	Ukwn%	Ttl	Ttl%
7	1994	776	97	19	2	1	0	796	100
8	1995	783	95	34	4	11	1	828	100
9	1996	731	96	27	4	3	0	761	100
10	1997	785	97	23	3	3	0	811	100
11	1998	741	98	16	2	0	0	757	100
Sheet1

 

[JenniferMurphy]

Try this -
For some reason over the years I don't prefer #, $ & * in header names as they can cause errors while analyzing. Also, if possible, avoid spaces in table names or header names, even with sheet names. Using small & Caps (TestExample) combination to keep them readable is my hack.

I like it. It's better than my solution and it can work for more than a few columns, which mine can't.

Thanks

PS: But I think M$FT needs to expand the table architecture to include multi-row headers, like in my example, and multple totals rows.

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.

Even I do feel need of multilevel or multi-row headers when creating summaries but have to live with limitations until Microsoft choose to find some solution to it.

 

[JenniferMurphy]

Glad to help you and thanks for the feedback.

You are welcome.

Even I do feel need of multilevel or multi-row headers when creating summaries but have to live with limitations until Microsoft choose to find some solution to it.

Don't hold your breath.