Reconstructed tidy output

Tidy rows for Table_4
Table_4
row	col	address	.value	age	age_source	sex	sex_source	measure	measure_source
7	2	R7C2	261	18 years (d)	R7C1	Males	R5C2	no.	R6C2
7	3	R7C3	0.6	18 years (d)	R7C1	Males	R5C2	%	R6C3
7	4	R7C4	148.5	18 years (d)	R7C1	Males	R5C2	Imprisonment rate (c)	R6C4
7	5	R7C5	24	18 years (d)	R7C1	Females	R5C5	no.	R6C5
7	6	R7C6	0.6	18 years (d)	R7C1	Females	R5C5	%	R6C6
7	7	R7C7	14.5	18 years (d)	R7C1	Females	R5C5	Imprisonment rate (c)	R6C7
7	8	R7C8	281	18 years (d)	R7C1	Persons (b)	R5C8	no.	R6C8
7	9	R7C9	0.6	18 years (d)	R7C1	Persons (b)	R5C8	%	R6C9
7	10	R7C10	82.4	18 years (d)	R7C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
8	2	R8C2	473	19 years	R8C1	Males	R5C2	no.	R6C2
8	3	R8C3	1.1	19 years	R8C1	Males	R5C2	%	R6C3
8	4	R8C4	265.5	19 years	R8C1	Males	R5C2	Imprisonment rate (c)	R6C4
8	5	R8C5	44	19 years	R8C1	Females	R5C5	no.	R6C5
8	6	R8C6	1.1	19 years	R8C1	Females	R5C5	%	R6C6
8	7	R8C7	26.3	19 years	R8C1	Females	R5C5	Imprisonment rate (c)	R6C7
8	8	R8C8	510	19 years	R8C1	Persons (b)	R5C8	no.	R6C8
8	9	R8C9	1.1	19 years	R8C1	Persons (b)	R5C8	%	R6C9
8	10	R8C10	147.6	19 years	R8C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
9	2	R9C2	4154	20–24 years	R9C1	Males	R5C2	no.	R6C2
9	3	R9C3	9.6	20–24 years	R9C1	Males	R5C2	%	R6C3
9	4	R9C4	439.5	20–24 years	R9C1	Males	R5C2	Imprisonment rate (c)	R6C4
9	5	R9C5	415	20–24 years	R9C1	Females	R5C5	no.	R6C5
9	6	R9C6	10.8	20–24 years	R9C1	Females	R5C5	%	R6C6
9	7	R9C7	47.5	20–24 years	R9C1	Females	R5C5	Imprisonment rate (c)	R6C7
9	8	R9C8	4565	20–24 years	R9C1	Persons (b)	R5C8	no.	R6C8
9	9	R9C9	9.7	20–24 years	R9C1	Persons (b)	R5C8	%	R6C9
9	10	R9C10	250.9	20–24 years	R9C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
10	2	R10C2	6241	25–29 years	R10C1	Males	R5C2	no.	R6C2
10	3	R10C3	14.5	25–29 years	R10C1	Males	R5C2	%	R6C3
10	4	R10C4	607.1	25–29 years	R10C1	Males	R5C2	Imprisonment rate (c)	R6C4
10	5	R10C5	627	25–29 years	R10C1	Females	R5C5	no.	R6C5
10	6	R10C6	16.4	25–29 years	R10C1	Females	R5C5	%	R6C6
10	7	R10C7	63	25–29 years	R10C1	Females	R5C5	Imprisonment rate (c)	R6C7
10	8	R10C8	6867	25–29 years	R10C1	Persons (b)	R5C8	no.	R6C8
10	9	R10C9	14.6	25–29 years	R10C1	Persons (b)	R5C8	%	R6C9
10	10	R10C10	339.3	25–29 years	R10C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
11	2	R11C2	7859	30–34 years	R11C1	Males	R5C2	no.	R6C2
11	3	R11C3	18.2	30–34 years	R11C1	Males	R5C2	%	R6C3
11	4	R11C4	766.8	30–34 years	R11C1	Males	R5C2	Imprisonment rate (c)	R6C4
11	5	R11C5	774	30–34 years	R11C1	Females	R5C5	no.	R6C5
11	6	R11C6	20.2	30–34 years	R11C1	Females	R5C5	%	R6C6
11	7	R11C7	74.8	30–34 years	R11C1	Females	R5C5	Imprisonment rate (c)	R6C7
11	8	R11C8	8633	30–34 years	R11C1	Persons (b)	R5C8	no.	R6C8
11	9	R11C9	18.4	30–34 years	R11C1	Persons (b)	R5C8	%	R6C9
11	10	R11C10	419.1	30–34 years	R11C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
12	2	R12C2	7238	35–39 years	R12C1	Males	R5C2	no.	R6C2
12	3	R12C3	16.8	35–39 years	R12C1	Males	R5C2	%	R6C3
12	4	R12C4	725.7	35–39 years	R12C1	Males	R5C2	Imprisonment rate (c)	R6C4
12	5	R12C5	648	35–39 years	R12C1	Females	R5C5	no.	R6C5
12	6	R12C6	16.9	35–39 years	R12C1	Females	R5C5	%	R6C6
12	7	R12C7	63.9	35–39 years	R12C1	Females	R5C5	Imprisonment rate (c)	R6C7
12	8	R12C8	7891	35–39 years	R12C1	Persons (b)	R5C8	no.	R6C8
12	9	R12C9	16.8	35–39 years	R12C1	Persons (b)	R5C8	%	R6C9
12	10	R12C10	392.4	35–39 years	R12C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
13	2	R13C2	5792	40–44 years	R13C1	Males	R5C2	no.	R6C2
13	3	R13C3	13.4	40–44 years	R13C1	Males	R5C2	%	R6C3
13	4	R13C4	614.5	40–44 years	R13C1	Males	R5C2	Imprisonment rate (c)	R6C4
13	5	R13C5	530	40–44 years	R13C1	Females	R5C5	no.	R6C5
13	6	R13C6	13.8	40–44 years	R13C1	Females	R5C5	%	R6C6
13	7	R13C7	55.5	40–44 years	R13C1	Females	R5C5	Imprisonment rate (c)	R6C7
13	8	R13C8	6320	40–44 years	R13C1	Persons (b)	R5C8	no.	R6C8
13	9	R13C9	13.4	40–44 years	R13C1	Persons (b)	R5C8	%	R6C9
13	10	R13C10	333	40–44 years	R13C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
14	2	R14C2	4095	45–49 years	R14C1	Males	R5C2	no.	R6C2
14	3	R14C3	9.5	45–49 years	R14C1	Males	R5C2	%	R6C3
14	4	R14C4	505.2	45–49 years	R14C1	Males	R5C2	Imprisonment rate (c)	R6C4
14	5	R14C5	341	45–49 years	R14C1	Females	R5C5	no.	R6C5
14	6	R14C6	8.9	45–49 years	R14C1	Females	R5C5	%	R6C6
14	7	R14C7	40.9	45–49 years	R14C1	Females	R5C5	Imprisonment rate (c)	R6C7
14	8	R14C8	4440	45–49 years	R14C1	Persons (b)	R5C8	no.	R6C8
14	9	R14C9	9.4	45–49 years	R14C1	Persons (b)	R5C8	%	R6C9
14	10	R14C10	269.9	45–49 years	R14C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
15	2	R15C2	2805	50–54 years	R15C1	Males	R5C2	no.	R6C2
15	3	R15C3	6.5	50–54 years	R15C1	Males	R5C2	%	R6C3
15	4	R15C4	337.7	50–54 years	R15C1	Males	R5C2	Imprisonment rate (c)	R6C4
15	5	R15C5	223	50–54 years	R15C1	Females	R5C5	no.	R6C5
15	6	R15C6	5.8	50–54 years	R15C1	Females	R5C5	%	R6C6
15	7	R15C7	26	50–54 years	R15C1	Females	R5C5	Imprisonment rate (c)	R6C7
15	8	R15C8	3025	50–54 years	R15C1	Persons (b)	R5C8	no.	R6C8
15	9	R15C9	6.4	50–54 years	R15C1	Persons (b)	R5C8	%	R6C9
15	10	R15C10	179.3	50–54 years	R15C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
16	2	R16C2	1688	55–59 years	R16C1	Males	R5C2	no.	R6C2
16	3	R16C3	3.9	55–59 years	R16C1	Males	R5C2	%	R6C3
16	4	R16C4	222.4	55–59 years	R16C1	Males	R5C2	Imprisonment rate (c)	R6C4
16	5	R16C5	90	55–59 years	R16C1	Females	R5C5	no.	R6C5
16	6	R16C6	2.3	55–59 years	R16C1	Females	R5C5	%	R6C6
16	7	R16C7	11.4	55–59 years	R16C1	Females	R5C5	Imprisonment rate (c)	R6C7
16	8	R16C8	1778	55–59 years	R16C1	Persons (b)	R5C8	no.	R6C8
16	9	R16C9	3.8	55–59 years	R16C1	Persons (b)	R5C8	%	R6C9
16	10	R16C10	114.8	55–59 years	R16C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
17	2	R17C2	987	60–64 years	R17C1	Males	R5C2	no.	R6C2
17	3	R17C3	2.3	60–64 years	R17C1	Males	R5C2	%	R6C3
17	4	R17C4	132	60–64 years	R17C1	Males	R5C2	Imprisonment rate (c)	R6C4
17	5	R17C5	65	60–64 years	R17C1	Females	R5C5	no.	R6C5
17	6	R17C6	1.7	60–64 years	R17C1	Females	R5C5	%	R6C6
17	7	R17C7	8.3	60–64 years	R17C1	Females	R5C5	Imprisonment rate (c)	R6C7
17	8	R17C8	1045	60–64 years	R17C1	Persons (b)	R5C8	no.	R6C8
17	9	R17C9	2.2	60–64 years	R17C1	Persons (b)	R5C8	%	R6C9
17	10	R17C10	68.1	60–64 years	R17C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
18	2	R18C2	1573	65 years and over	R18C1	Males	R5C2	no.	R6C2
18	3	R18C3	3.6	65 years and over	R18C1	Males	R5C2	%	R6C3
18	4	R18C4	70.2	65 years and over	R18C1	Males	R5C2	Imprisonment rate (c)	R6C4
18	5	R18C5	54	65 years and over	R18C1	Females	R5C5	no.	R6C5
18	6	R18C6	1.4	65 years and over	R18C1	Females	R5C5	%	R6C6
18	7	R18C7	2.1	65 years and over	R18C1	Females	R5C5	Imprisonment rate (c)	R6C7
18	8	R18C8	1631	65 years and over	R18C1	Persons (b)	R5C8	no.	R6C8
18	9	R18C9	3.5	65 years and over	R18C1	Persons (b)	R5C8	%	R6C9
18	10	R18C10	34	65 years and over	R18C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10
19	2	R19C2	43169	Total (e)	R19C1	Males	R5C2	no.	R6C2
19	3	R19C3	100	Total (e)	R19C1	Males	R5C2	%	R6C3
19	4	R19C4	404.2	Total (e)	R19C1	Males	R5C2	Imprisonment rate (c)	R6C4
19	5	R19C5	3831	Total (e)	R19C1	Females	R5C5	no.	R6C5
19	6	R19C6	100	Total (e)	R19C1	Females	R5C5	%	R6C6
19	7	R19C7	34.7	Total (e)	R19C1	Females	R5C5	Imprisonment rate (c)	R6C7
19	8	R19C8	46998	Total (e)	R19C1	Persons (b)	R5C8	no.	R6C8
19	9	R19C9	100	Total (e)	R19C1	Persons (b)	R5C8	%	R6C9
19	10	R19C10	216.4	Total (e)	R19C1	Persons (b)	R5C8	Imprisonment rate (c)	R6C10