Reconstructed tidy output

Long labels or cell text are truncated in this evidence view.

Tidy rows for table_2
table_2
row	col	address	.value	visa_stream	visa_stream_source	unit	unit_source	area	area_source	state	state_source
8	2	R8C2	481569	Skilled	R5C2	no.	R6C2	Greater Sydney	R8C1	New South Wales	R7C1
8	3	R8C3	312781	Family	R5C3	no.	R6C3	Greater Sydney	R8C1	New South Wales	R7C1
8	4	R8C4	86398	Humanitarian	R5C4	no.	R6C4	Greater Sydney	R8C1	New South Wales	R7C1
8	5	R8C5	396	Other permanent	R5C5	no.	R6C5	Greater Sydney	R8C1	New South Wales	R7C1
8	6	R8C6	881146	Total	R5C6	no.	R6C6	Greater Sydney	R8C1	New South Wales	R7C1
9	2	R9C2	55313	Skilled	R5C2	no.	R6C2	Rest of New South Wales	R9C1	New South Wales	R7C1
9	3	R9C3	41779	Family	R5C3	no.	R6C3	Rest of New South Wales	R9C1	New South Wales	R7C1
9	4	R9C4	9353	Humanitarian	R5C4	no.	R6C4	Rest of New South Wales	R9C1	New South Wales	R7C1
9	5	R9C5	49	Other permanent	R5C5	no.	R6C5	Rest of New South Wales	R9C1	New South Wales	R7C1
9	6	R9C6	106498	Total	R5C6	no.	R6C6	Rest of New South Wales	R9C1	New South Wales	R7C1
10	2	R10C2	537121	Skilled	R5C2	no.	R6C2	Total (a)	R10C1	New South Wales	R7C1
10	3	R10C3	354728	Family	R5C3	no.	R6C3	Total (a)	R10C1	New South Wales	R7C1
10	4	R10C4	95797	Humanitarian	R5C4	no.	R6C4	Total (a)	R10C1	New South Wales	R7C1
10	5	R10C5	448	Other permanent	R5C5	no.	R6C5	Total (a)	R10C1	New South Wales	R7C1
10	6	R10C6	988099	Total	R5C6	no.	R6C6	Total (a)	R10C1	New South Wales	R7C1
12	2	R12C2	465129	Skilled	R5C2	no.	R6C2	Greater Melbourne	R12C1	Victoria	R11C1
12	3	R12C3	249190	Family	R5C3	no.	R6C3	Greater Melbourne	R12C1	Victoria	R11C1
12	4	R12C4	86426	Humanitarian	R5C4	no.	R6C4	Greater Melbourne	R12C1	Victoria	R11C1
12	5	R12C5	255	Other permanent	R5C5	no.	R6C5	Greater Melbourne	R12C1	Victoria	R11C1
12	6	R12C6	800996	Total	R5C6	no.	R6C6	Greater Melbourne	R12C1	Victoria	R11C1
13	2	R13C2	31869	Skilled	R5C2	no.	R6C2	Rest of Victoria	R13C1	Victoria	R11C1
13	3	R13C3	22875	Family	R5C3	no.	R6C3	Rest of Victoria	R13C1	Victoria	R11C1
13	4	R13C4	7827	Humanitarian	R5C4	no.	R6C4	Rest of Victoria	R13C1	Victoria	R11C1
13	5	R13C5	60	Other permanent	R5C5	no.	R6C5	Rest of Victoria	R13C1	Victoria	R11C1
13	6	R13C6	62625	Total	R5C6	no.	R6C6	Rest of Victoria	R13C1	Victoria	R11C1
14	2	R14C2	497157	Skilled	R5C2	no.	R6C2	Total (a)	R14C1	Victoria	R11C1
14	3	R14C3	272262	Family	R5C3	no.	R6C3	Total (a)	R14C1	Victoria	R11C1
14	4	R14C4	94342	Humanitarian	R5C4	no.	R6C4	Total (a)	R14C1	Victoria	R11C1
14	5	R14C5	305	Other permanent	R5C5	no.	R6C5	Total (a)	R14C1	Victoria	R11C1
14	6	R14C6	864067	Total	R5C6	no.	R6C6	Total (a)	R14C1	Victoria	R11C1
16	2	R16C2	175022	Skilled	R5C2	no.	R6C2	Greater Brisbane	R16C1	Queensland	R15C1
16	3	R16C3	89450	Family	R5C3	no.	R6C3	Greater Brisbane	R16C1	Queensland	R15C1
16	4	R16C4	26896	Humanitarian	R5C4	no.	R6C4	Greater Brisbane	R16C1	Queensland	R15C1
16	5	R16C5	102	Other permanent	R5C5	no.	R6C5	Greater Brisbane	R16C1	Queensland	R15C1
16	6	R16C6	291466	Total	R5C6	no.	R6C6	Greater Brisbane	R16C1	Queensland	R15C1
17	2	R17C2	103903	Skilled	R5C2	no.	R6C2	Rest of Queensland	R17C1	Queensland	R15C1
17	3	R17C3	60514	Family	R5C3	no.	R6C3	Rest of Queensland	R17C1	Queensland	R15C1
17	4	R17C4	9021	Humanitarian	R5C4	no.	R6C4	Rest of Queensland	R17C1	Queensland	R15C1
17	5	R17C5	76	Other permanent	R5C5	no.	R6C5	Rest of Queensland	R17C1	Queensland	R15C1
17	6	R17C6	173510	Total	R5C6	no.	R6C6	Rest of Queensland	R17C1	Queensland	R15C1
18	2	R18C2	279214	Skilled	R5C2	no.	R6C2	Total (a)	R18C1	Queensland	R15C1
18	3	R18C3	150164	Family	R5C3	no.	R6C3	Total (a)	R18C1	Queensland	R15C1
18	4	R18C4	35958	Humanitarian	R5C4	no.	R6C4	Total (a)	R18C1	Queensland	R15C1
18	5	R18C5	170	Other permanent	R5C5	no.	R6C5	Total (a)	R18C1	Queensland	R15C1
18	6	R18C6	465512	Total	R5C6	no.	R6C6	Total (a)	R18C1	Queensland	R15C1
20	2	R20C2	102198	Skilled	R5C2	no.	R6C2	Greater Adelaide	R20C1	South Australia	R19C1
20	3	R20C3	41976	Family	R5C3	no.	R6C3	Greater Adelaide	R20C1	South Australia	R19C1
20	4	R20C4	23454	Humanitarian	R5C4	no.	R6C4	Greater Adelaide	R20C1	South Australia	R19C1
20	5	R20C5	62	Other permanent	R5C5	no.	R6C5	Greater Adelaide	R20C1	South Australia	R19C1
20	6	R20C6	167690	Total	R5C6	no.	R6C6	Greater Adelaide	R20C1	South Australia	R19C1
21	2	R21C2	5867	Skilled	R5C2	no.	R6C2	Rest of South Australia	R21C1	South Australia	R19C1
21	3	R21C3	4160	Family	R5C3	no.	R6C3	Rest of South Australia	R21C1	South Australia	R19C1
21	4	R21C4	778	Humanitarian	R5C4	no.	R6C4	Rest of South Australia	R21C1	South Australia	R19C1
21	5	R21C5	4	Other permanent	R5C5	no.	R6C5	Rest of South Australia	R21C1	South Australia	R19C1
21	6	R21C6	10817	Total	R5C6	no.	R6C6	Rest of South Australia	R21C1	South Australia	R19C1
22	2	R22C2	108138	Skilled	R5C2	no.	R6C2	Total (a)	R22C1	South Australia	R19C1
22	3	R22C3	46186	Family	R5C3	no.	R6C3	Total (a)	R22C1	South Australia	R19C1
22	4	R22C4	24261	Humanitarian	R5C4	no.	R6C4	Total (a)	R22C1	South Australia	R19C1
22	5	R22C5	69	Other permanent	R5C5	no.	R6C5	Total (a)	R22C1	South Australia	R19C1
22	6	R22C6	178661	Total	R5C6	no.	R6C6	Total (a)	R22C1	South Australia	R19C1
24	2	R24C2	245115	Skilled	R5C2	no.	R6C2	Greater Perth	R24C1	Western Australia	R23C1
24	3	R24C3	95759	Family	R5C3	no.	R6C3	Greater Perth	R24C1	Western Australia	R23C1
24	4	R24C4	23675	Humanitarian	R5C4	no.	R6C4	Greater Perth	R24C1	Western Australia	R23C1
24	5	R24C5	189	Other permanent	R5C5	no.	R6C5	Greater Perth	R24C1	Western Australia	R23C1
24	6	R24C6	364730	Total	R5C6	no.	R6C6	Greater Perth	R24C1	Western Australia	R23C1
25	2	R25C2	21975	Skilled	R5C2	no.	R6C2	Rest of Western Austral…	R25C1	Western Australia	R23C1
25	3	R25C3	10916	Family	R5C3	no.	R6C3	Rest of Western Austral…	R25C1	Western Australia	R23C1
25	4	R25C4	799	Humanitarian	R5C4	no.	R6C4	Rest of Western Austral…	R25C1	Western Australia	R23C1
25	5	R25C5	4	Other permanent	R5C5	no.	R6C5	Rest of Western Austral…	R25C1	Western Australia	R23C1
25	6	R25C6	33695	Total	R5C6	no.	R6C6	Rest of Western Austral…	R25C1	Western Australia	R23C1
26	2	R26C2	267299	Skilled	R5C2	no.	R6C2	Total (a)	R26C1	Western Australia	R23C1
26	3	R26C3	106795	Family	R5C3	no.	R6C3	Total (a)	R26C1	Western Australia	R23C1
26	4	R26C4	24521	Humanitarian	R5C4	no.	R6C4	Total (a)	R26C1	Western Australia	R23C1
26	5	R26C5	193	Other permanent	R5C5	no.	R6C5	Total (a)	R26C1	Western Australia	R23C1
26	6	R26C6	398808	Total	R5C6	no.	R6C6	Total (a)	R26C1	Western Australia	R23C1
28	2	R28C2	11743	Skilled	R5C2	no.	R6C2	Greater Hobart	R28C1	Tasmania	R27C1
28	3	R28C3	4130	Family	R5C3	no.	R6C3	Greater Hobart	R28C1	Tasmania	R27C1
28	4	R28C4	1903	Humanitarian	R5C4	no.	R6C4	Greater Hobart	R28C1	Tasmania	R27C1
28	5	R28C5	0	Other permanent	R5C5	no.	R6C5	Greater Hobart	R28C1	Tasmania	R27C1
28	6	R28C6	17771	Total	R5C6	no.	R6C6	Greater Hobart	R28C1	Tasmania	R27C1
29	2	R29C2	5734	Skilled	R5C2	no.	R6C2	Rest of Tasmania	R29C1	Tasmania	R27C1
29	3	R29C3	3738	Family	R5C3	no.	R6C3	Rest of Tasmania	R29C1	Tasmania	R27C1
29	4	R29C4	1937	Humanitarian	R5C4	no.	R6C4	Rest of Tasmania	R29C1	Tasmania	R27C1
29	5	R29C5	20	Other permanent	R5C5	no.	R6C5	Rest of Tasmania	R29C1	Tasmania	R27C1
29	6	R29C6	11433	Total	R5C6	no.	R6C6	Rest of Tasmania	R29C1	Tasmania	R27C1
30	2	R30C2	17491	Skilled	R5C2	no.	R6C2	Total (a)	R30C1	Tasmania	R27C1
30	3	R30C3	7879	Family	R5C3	no.	R6C3	Total (a)	R30C1	Tasmania	R27C1
30	4	R30C4	3841	Humanitarian	R5C4	no.	R6C4	Total (a)	R30C1	Tasmania	R27C1
30	5	R30C5	21	Other permanent	R5C5	no.	R6C5	Total (a)	R30C1	Tasmania	R27C1
30	6	R30C6	29234	Total	R5C6	no.	R6C6	Total (a)	R30C1	Tasmania	R27C1
32	2	R32C2	12974	Skilled	R5C2	no.	R6C2	Greater Darwin	R32C1	Northern Territory	R31C1
32	3	R32C3	5797	Family	R5C3	no.	R6C3	Greater Darwin	R32C1	Northern Territory	R31C1
32	4	R32C4	976	Humanitarian	R5C4	no.	R6C4	Greater Darwin	R32C1	Northern Territory	R31C1
32	5	R32C5	6	Other permanent	R5C5	no.	R6C5	Greater Darwin	R32C1	Northern Territory	R31C1
32	6	R32C6	19755	Total	R5C6	no.	R6C6	Greater Darwin	R32C1	Northern Territory	R31C1
33	2	R33C2	3117	Skilled	R5C2	no.	R6C2	Rest of Northern Territ…	R33C1	Northern Territory	R31C1
33	3	R33C3	1539	Family	R5C3	no.	R6C3	Rest of Northern Territ…	R33C1	Northern Territory	R31C1
33	4	R33C4	291	Humanitarian	R5C4	no.	R6C4	Rest of Northern Territ…	R33C1	Northern Territory	R31C1
33	5	R33C5	0	Other permanent	R5C5	no.	R6C5	Rest of Northern Territ…	R33C1	Northern Territory	R31C1
33	6	R33C6	4947	Total	R5C6	no.	R6C6	Rest of Northern Territ…	R33C1	Northern Territory	R31C1
34	2	R34C2	16168	Skilled	R5C2	no.	R6C2	Total (a)	R34C1	Northern Territory	R31C1
34	3	R34C3	7372	Family	R5C3	no.	R6C3	Total (a)	R34C1	Northern Territory	R31C1
34	4	R34C4	1266	Humanitarian	R5C4	no.	R6C4	Total (a)	R34C1	Northern Territory	R31C1
34	5	R34C5	6	Other permanent	R5C5	no.	R6C5	Total (a)	R34C1	Northern Territory	R31C1
34	6	R34C6	24813	Total	R5C6	no.	R6C6	Total (a)	R34C1	Northern Territory	R31C1
36	2	R36C2	38386	Skilled	R5C2	no.	R6C2	Australian Capital Terr…	R36C1	Australian Capital Terr…	R35C1
36	3	R36C3	16732	Family	R5C3	no.	R6C3	Australian Capital Terr…	R36C1	Australian Capital Terr…	R35C1
36	4	R36C4	3551	Humanitarian	R5C4	no.	R6C4	Australian Capital Terr…	R36C1	Australian Capital Terr…	R35C1
36	5	R36C5	8	Other permanent	R5C5	no.	R6C5	Australian Capital Terr…	R36C1	Australian Capital Terr…	R35C1
36	6	R36C6	58676	Total	R5C6	no.	R6C6	Australian Capital Terr…	R36C1	Australian Capital Terr…	R35C1
37	2	R37C2	38402	Skilled	R5C2	no.	R6C2	Total (a)	R37C1	Australian Capital Terr…	R35C1
37	3	R37C3	16740	Family	R5C3	no.	R6C3	Total (a)	R37C1	Australian Capital Terr…	R35C1
37	4	R37C4	3551	Humanitarian	R5C4	no.	R6C4	Total (a)	R37C1	Australian Capital Terr…	R35C1
37	5	R37C5	8	Other permanent	R5C5	no.	R6C5	Total (a)	R37C1	Australian Capital Terr…	R35C1
37	6	R37C6	58703	Total	R5C6	no.	R6C6	Total (a)	R37C1	Australian Capital Terr…	R35C1
39	2	R39C2	54	Skilled	R5C2	no.	R6C2	Other Territories	R39C1	Other Territories	R38C1
39	3	R39C3	230	Family	R5C3	no.	R6C3	Other Territories	R39C1	Other Territories	R38C1
39	4	R39C4	8	Humanitarian	R5C4	no.	R6C4	Other Territories	R39C1	Other Territories	R38C1
39	5	R39C5	0	Other permanent	R5C5	no.	R6C5	Other Territories	R39C1	Other Territories	R38C1
39	6	R39C6	294	Total	R5C6	no.	R6C6	Other Territories	R39C1	Other Territories	R38C1
40	2	R40C2	54	Skilled	R5C2	no.	R6C2	Total (a)	R40C1	Other Territories	R38C1
40	3	R40C3	230	Family	R5C3	no.	R6C3	Total (a)	R40C1	Other Territories	R38C1
40	4	R40C4	8	Humanitarian	R5C4	no.	R6C4	Total (a)	R40C1	Other Territories	R38C1
40	5	R40C5	0	Other permanent	R5C5	no.	R6C5	Total (a)	R40C1	Other Territories	R38C1
40	6	R40C6	294	Total	R5C6	no.	R6C6	Total (a)	R40C1	Other Territories	R38C1
41	2	R41C2	1761040	Skilled	R5C2	no.	R6C2	Australia (a)	R41C1	Other Territories	R38C1
41	3	R41C3	962350	Family	R5C3	no.	R6C3	Australia (a)	R41C1	Other Territories	R38C1
41	4	R41C4	283552	Humanitarian	R5C4	no.	R6C4	Australia (a)	R41C1	Other Territories	R38C1
41	5	R41C5	1242	Other permanent	R5C5	no.	R6C5	Australia (a)	R41C1	Other Territories	R38C1
41	6	R41C6	3008179	Total	R5C6	no.	R6C6	Australia (a)	R41C1	Other Territories	R38C1