Standardize table output: Connect parent row information to each row it applies to

[Elijas]

Context

Table as it appears originally in the report

                                               1                   2                   3                  4                  5
0                                                 Three Months Ended  Three Months Ended  Nine Months Ended  Nine Months Ended
1                                                       July 1, 2023       June 25, 2022       July 1, 2023      June 25, 2022
2                                     Net sales:                                                                              
3                                       Products              $60584              $63355            $230901            $245241
4                                       Services               21213               19604              62886              58941
5                                Total net sales               81797               82959             293787             304182
6                                 Cost of sales:                                                                              
7                                       Products               39136               41485             146696             155084
8                                       Services                6248                5589              18370              16411
9                            Total cost of sales               45384               47074             165066             171495
10                                  Gross margin               36413               35885             128721             132687
11                           Operating expenses:                                                                              
12                      Research and development                7442                6797              22608              19490
13           Selling, general and administrative                5973                6012              18781              18654
14                      Total operating expenses               13415               12809              41389              38144
15                              Operating income               22998               23076              87332              94543
16                   Other income/(expense), net               (265)                (10)              (594)               (97)
17      Income before provision for income taxes               22733               23066              86738              94446
18                    Provision for income taxes                2852                3624              12699              15364
19                                    Net income              $19881              $19442             $74039             $79082
20                           Earnings per share:                                                                              
21                                         Basic               $1.27               $1.20              $4.69              $4.86
22                                       Diluted               $1.26               $1.20              $4.67              $4.82
23  Shares used in computing earnings per share:                                                                              
24                                         Basic            15697614            16162945           15792497           16277824
25                                       Diluted            15775021            16262203           15859263           16394937

Semi-standardized table

                                             Key     Value                              Period
0                                     Net sales:                                              
1                                       Products    $60584   Three Months Ended (July 1, 2023)
2                                       Services     21213   Three Months Ended (July 1, 2023)
3                                Total net sales     81797   Three Months Ended (July 1, 2023)
4                                 Cost of sales:                                              
5                                       Products     39136   Three Months Ended (July 1, 2023)
6                                       Services      6248   Three Months Ended (July 1, 2023)
7                            Total cost of sales     45384   Three Months Ended (July 1, 2023)
8                                   Gross margin     36413   Three Months Ended (July 1, 2023)
9                            Operating expenses:                                              
10                      Research and development      7442   Three Months Ended (July 1, 2023)
11           Selling, general and administrative      5973   Three Months Ended (July 1, 2023)
12                      Total operating expenses     13415   Three Months Ended (July 1, 2023)
13                              Operating income     22998   Three Months Ended (July 1, 2023)
14                   Other income/(expense), net     (265)   Three Months Ended (July 1, 2023)
15      Income before provision for income taxes     22733   Three Months Ended (July 1, 2023)
16                    Provision for income taxes      2852   Three Months Ended (July 1, 2023)
17                                    Net income    $19881   Three Months Ended (July 1, 2023)
18                           Earnings per share:                                              
19                                         Basic     $1.27   Three Months Ended (July 1, 2023)
20                                       Diluted     $1.26   Three Months Ended (July 1, 2023)
21  Shares used in computing earnings per share:                                              
22                                         Basic  15697614   Three Months Ended (July 1, 2023)
23                                       Diluted  15775021   Three Months Ended (July 1, 2023)
24                                    Net sales:                                              
25                                      Products    $63355  Three Months Ended (June 25, 2022)
26                                      Services     19604  Three Months Ended (June 25, 2022)
27                               Total net sales     82959  Three Months Ended (June 25, 2022)
28                                Cost of sales:                                              
29                                      Products     41485  Three Months Ended (June 25, 2022)
30                                      Services      5589  Three Months Ended (June 25, 2022)
31                           Total cost of sales     47074  Three Months Ended (June 25, 2022)
32                                  Gross margin     35885  Three Months Ended (June 25, 2022)
33                           Operating expenses:                                              
34                      Research and development      6797  Three Months Ended (June 25, 2022)
35           Selling, general and administrative      6012  Three Months Ended (June 25, 2022)
36                      Total operating expenses     12809  Three Months Ended (June 25, 2022)
37                              Operating income     23076  Three Months Ended (June 25, 2022)
38                   Other income/(expense), net      (10)  Three Months Ended (June 25, 2022)
39      Income before provision for income taxes     23066  Three Months Ended (June 25, 2022)
40                    Provision for income taxes      3624  Three Months Ended (June 25, 2022)
41                                    Net income    $19442  Three Months Ended (June 25, 2022)
42                           Earnings per share:                                              
43                                         Basic     $1.20  Three Months Ended (June 25, 2022)
44                                       Diluted     $1.20  Three Months Ended (June 25, 2022)
45  Shares used in computing earnings per share:                                              
46                                         Basic  16162945  Three Months Ended (June 25, 2022)
47                                       Diluted  16262203  Three Months Ended (June 25, 2022)
48                                    Net sales:                                              
49                                      Products   $230901    Nine Months Ended (July 1, 2023)
50                                      Services     62886    Nine Months Ended (July 1, 2023)
51                               Total net sales    293787    Nine Months Ended (July 1, 2023)
52                                Cost of sales:                                              
53                                      Products    146696    Nine Months Ended (July 1, 2023)
54                                      Services     18370    Nine Months Ended (July 1, 2023)
55                           Total cost of sales    165066    Nine Months Ended (July 1, 2023)
56                                  Gross margin    128721    Nine Months Ended (July 1, 2023)
57                           Operating expenses:                                              
58                      Research and development     22608    Nine Months Ended (July 1, 2023)
59           Selling, general and administrative     18781    Nine Months Ended (July 1, 2023)
60                      Total operating expenses     41389    Nine Months Ended (July 1, 2023)
61                              Operating income     87332    Nine Months Ended (July 1, 2023)
62                   Other income/(expense), net     (594)    Nine Months Ended (July 1, 2023)
63      Income before provision for income taxes     86738    Nine Months Ended (July 1, 2023)
64                    Provision for income taxes     12699    Nine Months Ended (July 1, 2023)
65                                    Net income    $74039    Nine Months Ended (July 1, 2023)
66                           Earnings per share:                                              
67                                         Basic     $4.69    Nine Months Ended (July 1, 2023)
68                                       Diluted     $4.67    Nine Months Ended (July 1, 2023)
69  Shares used in computing earnings per share:                                              
70                                         Basic  15792497    Nine Months Ended (July 1, 2023)
71                                       Diluted  15859263    Nine Months Ended (July 1, 2023)
72                                    Net sales:                                              
73                                      Products   $245241   Nine Months Ended (June 25, 2022)
74                                      Services     58941   Nine Months Ended (June 25, 2022)
75                               Total net sales    304182   Nine Months Ended (June 25, 2022)
76                                Cost of sales:                                              
77                                      Products    155084   Nine Months Ended (June 25, 2022)
78                                      Services     16411   Nine Months Ended (June 25, 2022)
79                           Total cost of sales    171495   Nine Months Ended (June 25, 2022)
80                                  Gross margin    132687   Nine Months Ended (June 25, 2022)
81                           Operating expenses:                                              
82                      Research and development     19490   Nine Months Ended (June 25, 2022)
83           Selling, general and administrative     18654   Nine Months Ended (June 25, 2022)
84                      Total operating expenses     38144   Nine Months Ended (June 25, 2022)
85                              Operating income     94543   Nine Months Ended (June 25, 2022)
86                   Other income/(expense), net      (97)   Nine Months Ended (June 25, 2022)
87      Income before provision for income taxes     94446   Nine Months Ended (June 25, 2022)
88                    Provision for income taxes     15364   Nine Months Ended (June 25, 2022)
89                                    Net income    $79082   Nine Months Ended (June 25, 2022)
90                           Earnings per share:                                              
91                                         Basic     $4.86   Nine Months Ended (June 25, 2022)
92                                       Diluted     $4.82   Nine Months Ended (June 25, 2022)
93  Shares used in computing earnings per share:                                              
94                                         Basic  16277824   Nine Months Ended (June 25, 2022)
95                                       Diluted  16394937   Nine Months Ended (June 25, 2022)

Source: Table from recent AAPL 10-Q filing

Task

For example, we'd want the current output

                                             Key     Value                              Period
0                                     Net sales:                                              
1                                       Products    $60584   Three Months Ended (July 1, 2023)
2                                       Services     21213   Three Months Ended (July 1, 2023)
3                                Total net sales     81797   Three Months Ended (July 1, 2023)

to become

                                             Key     Value                              Period
0                            Net sales: Products    $60584   Three Months Ended (July 1, 2023)   
1                            Net sales: Services     21213   Three Months Ended (July 1, 2023)
2                     Net sales: Total net sales     81797   Three Months Ended (July 1, 2023)

Or become its multi-indexed alternative. Each output style has pros and cons, but they're interchangeable, so it doesn't matter too much.

Some ideas how to achieve it (they can also be mixed):

• Empty rows in tables
• Indentation in key names.

Note

This task is tentative, feel free to start a discussion to propose a better alternative. You can do it in the comments below or in the #sec-parser-tables channel.

Currently working on it

• @nnilayy
• @INF800
• If you'd like to contribute, reach out in the comments below or in the Discord channel #sec-parser-tables

[rozeappletree]

Using the 1. Empty rows in tables, we can achieve this very well.

Example outputs:

Table 1 input

	1	2	3	4	5
0
1		Three Months Ended	Three Months Ended	Nine Months Ended	Nine Months Ended
2		July 1, 2023	June 25, 2022	July 1, 2023	June 25, 2022
3	Net sales:
4	Products	$60584	$63355	$230901	$245241
5	Services	21213	19604	62886	58941
6	Total net sales	81797	82959	293787	304182
7
8	Cost of sales:
9	Products	39136	41485	146696	155084
10	Services	6248	5589	18370	16411
11	Total cost of sales	45384	47074	165066	171495
12	Gross margin	36413	35885	128721	132687
13
14	Operating expenses:
15	Research and development	7442	6797	22608	19490
16	Selling, general and administrative	5973	6012	18781	18654
17	Total operating expenses	13415	12809	41389	38144
18
19	Operating income	22998	23076	87332	94543
20	Other income/(expense), net	(265)	(10)	(594)	(97)
21	Income before provision for income taxes	22733	23066	86738	94446
22	Provision for income taxes	2852	3624	12699	15364
23	Net income	$19881	$19442	$74039	$79082
24
25	Earnings per share:
26	Basic	$1.27	$1.20	$4.69	$4.86
27	Diluted	$1.26	$1.20	$4.67	$4.82
28
29	Shares used in computing earnings per share:
30	Basic	15697614	16162945	15792497	16277824
31	Diluted	15775021	16262203	15859263	16394937

Table 1 output

	Key	Value	Period
0	Net sales: Products	$60584	Three Months Ended (July 1, 2023)
1	Net sales: Services	21213	Three Months Ended (July 1, 2023)
2	Net sales: Total net sales	81797	Three Months Ended (July 1, 2023)
3	Cost of sales: Products	39136	Three Months Ended (July 1, 2023)
4	Cost of sales: Services	6248	Three Months Ended (July 1, 2023)
5	Cost of sales: Total cost of sales	45384	Three Months Ended (July 1, 2023)
6	Cost of sales: Gross margin	36413	Three Months Ended (July 1, 2023)
7	Operating expenses: Research and development	7442	Three Months Ended (July 1, 2023)
8	Operating expenses: Selling, general and administrative	5973	Three Months Ended (July 1, 2023)
9	Operating expenses: Total operating expenses	13415	Three Months Ended (July 1, 2023)
10	Operating income	22998	Three Months Ended (July 1, 2023)
11	Other income/(expense), net	(265)	Three Months Ended (July 1, 2023)
12	Income before provision for income taxes	22733	Three Months Ended (July 1, 2023)
13	Provision for income taxes	2852	Three Months Ended (July 1, 2023)
14	Net income	$19881	Three Months Ended (July 1, 2023)
15	Earnings per share: Basic	$1.27	Three Months Ended (July 1, 2023)
16	Earnings per share: Diluted	$1.26	Three Months Ended (July 1, 2023)
17	Shares used in computing earnings per share: Basic	15697614	Three Months Ended (July 1, 2023)
18	Shares used in computing earnings per share: Diluted	15775021	Three Months Ended (July 1, 2023)
19	Net sales: Products	$63355	Three Months Ended (June 25, 2022)
20	Net sales: Services	19604	Three Months Ended (June 25, 2022)
21	Net sales: Total net sales	82959	Three Months Ended (June 25, 2022)
22	Cost of sales: Products	41485	Three Months Ended (June 25, 2022)
23	Cost of sales: Services	5589	Three Months Ended (June 25, 2022)
24	Cost of sales: Total cost of sales	47074	Three Months Ended (June 25, 2022)
25	Cost of sales: Gross margin	35885	Three Months Ended (June 25, 2022)
26	Operating expenses: Research and development	6797	Three Months Ended (June 25, 2022)
27	Operating expenses: Selling, general and administrative	6012	Three Months Ended (June 25, 2022)
28	Operating expenses: Total operating expenses	12809	Three Months Ended (June 25, 2022)
29	Operating income	23076	Three Months Ended (June 25, 2022)
30	Other income/(expense), net	(10)	Three Months Ended (June 25, 2022)
31	Income before provision for income taxes	23066	Three Months Ended (June 25, 2022)
32	Provision for income taxes	3624	Three Months Ended (June 25, 2022)
33	Net income	$19442	Three Months Ended (June 25, 2022)
34	Earnings per share: Basic	$1.20	Three Months Ended (June 25, 2022)
35	Earnings per share: Diluted	$1.20	Three Months Ended (June 25, 2022)
36	Shares used in computing earnings per share: Basic	16162945	Three Months Ended (June 25, 2022)
37	Shares used in computing earnings per share: Diluted	16262203	Three Months Ended (June 25, 2022)
38	Net sales: Products	$230901	Nine Months Ended (July 1, 2023)
39	Net sales: Services	62886	Nine Months Ended (July 1, 2023)
40	Net sales: Total net sales	293787	Nine Months Ended (July 1, 2023)
41	Cost of sales: Products	146696	Nine Months Ended (July 1, 2023)
42	Cost of sales: Services	18370	Nine Months Ended (July 1, 2023)
43	Cost of sales: Total cost of sales	165066	Nine Months Ended (July 1, 2023)
44	Cost of sales: Gross margin	128721	Nine Months Ended (July 1, 2023)
45	Operating expenses: Research and development	22608	Nine Months Ended (July 1, 2023)
46	Operating expenses: Selling, general and administrative	18781	Nine Months Ended (July 1, 2023)
47	Operating expenses: Total operating expenses	41389	Nine Months Ended (July 1, 2023)
48	Operating income	87332	Nine Months Ended (July 1, 2023)
49	Other income/(expense), net	(594)	Nine Months Ended (July 1, 2023)
50	Income before provision for income taxes	86738	Nine Months Ended (July 1, 2023)
51	Provision for income taxes	12699	Nine Months Ended (July 1, 2023)
52	Net income	$74039	Nine Months Ended (July 1, 2023)
53	Earnings per share: Basic	$4.69	Nine Months Ended (July 1, 2023)
54	Earnings per share: Diluted	$4.67	Nine Months Ended (July 1, 2023)
55	Shares used in computing earnings per share: Basic	15792497	Nine Months Ended (July 1, 2023)
56	Shares used in computing earnings per share: Diluted	15859263	Nine Months Ended (July 1, 2023)
57	Net sales: Products	$245241	Nine Months Ended (June 25, 2022)
58	Net sales: Services	58941	Nine Months Ended (June 25, 2022)
59	Net sales: Total net sales	304182	Nine Months Ended (June 25, 2022)
60	Cost of sales: Products	155084	Nine Months Ended (June 25, 2022)
61	Cost of sales: Services	16411	Nine Months Ended (June 25, 2022)
62	Cost of sales: Total cost of sales	171495	Nine Months Ended (June 25, 2022)
63	Cost of sales: Gross margin	132687	Nine Months Ended (June 25, 2022)
64	Operating expenses: Research and development	19490	Nine Months Ended (June 25, 2022)
65	Operating expenses: Selling, general and administrative	18654	Nine Months Ended (June 25, 2022)
66	Operating expenses: Total operating expenses	38144	Nine Months Ended (June 25, 2022)
67	Operating income	94543	Nine Months Ended (June 25, 2022)
68	Other income/(expense), net	(97)	Nine Months Ended (June 25, 2022)
69	Income before provision for income taxes	94446	Nine Months Ended (June 25, 2022)
70	Provision for income taxes	15364	Nine Months Ended (June 25, 2022)
71	Net income	$79082	Nine Months Ended (June 25, 2022)
72	Earnings per share: Basic	$4.86	Nine Months Ended (June 25, 2022)
73	Earnings per share: Diluted	$4.82	Nine Months Ended (June 25, 2022)
74	Shares used in computing earnings per share: Basic	16277824	Nine Months Ended (June 25, 2022)
75	Shares used in computing earnings per share: Diluted	16394937	Nine Months Ended (June 25, 2022)

Table 2 input

	1	2	3	4	5
0
1		Three Months Ended	Three Months Ended	Nine Months Ended	Nine Months Ended
2		July 1, 2023	June 25, 2022	July 1, 2023	June 25, 2022
3	Net income	$19881	$19442	$74039	$79082
4	Other comprehensive income/(loss):
5	Change in foreign currency translation, net of tax	(385)	(721)	(494)	(1,102)
6
7	Change in unrealized gains/losses on derivative instruments, net of tax:
8	Change in fair value of derivative instruments	509	852	(492)	1548
9	Adjustment for net (gains)/losses realized and included in net income	103	121	(1,854)	(87)
10	Total change in unrealized gains/losses on derivative instruments	612	973	(2,346)	1461
11
12	Change in unrealized gains/losses on marketable debt securities, net of tax:
13	Change in fair value of marketable debt securities	(340)	(3,150)	1963	(9,959)
14	Adjustment for net (gains)/losses realized and included in net income	58	95	185	140
15	Total change in unrealized gains/losses on marketable debt securities	(282)	(3,055)	2148	(9,819)
16
17	Total other comprehensive income/(loss)	(55)	(2,803)	(692)	(9,460)
18	Total comprehensive income	$19826	$16639	$73347	$69622

Table 2 output

	Key	Value	Period
0	Net income	$19881	Three Months Ended (July 1, 2023)
1	Other comprehensive income/(loss): Change in foreign currency translation, net of tax	(385)	Three Months Ended (July 1, 2023)
2	Change in unrealized gains/losses on derivative instruments, net of tax: Change in fair value of derivative instruments	509	Three Months Ended (July 1, 2023)
3	Change in unrealized gains/losses on derivative instruments, net of tax: Adjustment for net (gains)/losses realized and included in net income	103	Three Months Ended (July 1, 2023)
4	Change in unrealized gains/losses on derivative instruments, net of tax: Total change in unrealized gains/losses on derivative instruments	612	Three Months Ended (July 1, 2023)
5	Change in unrealized gains/losses on marketable debt securities, net of tax: Change in fair value of marketable debt securities	(340)	Three Months Ended (July 1, 2023)
6	Change in unrealized gains/losses on marketable debt securities, net of tax: Adjustment for net (gains)/losses realized and included in net income	58	Three Months Ended (July 1, 2023)
7	Change in unrealized gains/losses on marketable debt securities, net of tax: Total change in unrealized gains/losses on marketable debt securities	(282)	Three Months Ended (July 1, 2023)
8	Total other comprehensive income/(loss)	(55)	Three Months Ended (July 1, 2023)
9	Total comprehensive income	$19826	Three Months Ended (July 1, 2023)
10	Net income	$19442	Three Months Ended (June 25, 2022)
11	Other comprehensive income/(loss): Change in foreign currency translation, net of tax	(721)	Three Months Ended (June 25, 2022)
12	Change in unrealized gains/losses on derivative instruments, net of tax: Change in fair value of derivative instruments	852	Three Months Ended (June 25, 2022)
13	Change in unrealized gains/losses on derivative instruments, net of tax: Adjustment for net (gains)/losses realized and included in net income	121	Three Months Ended (June 25, 2022)
14	Change in unrealized gains/losses on derivative instruments, net of tax: Total change in unrealized gains/losses on derivative instruments	973	Three Months Ended (June 25, 2022)
15	Change in unrealized gains/losses on marketable debt securities, net of tax: Change in fair value of marketable debt securities	(3,150)	Three Months Ended (June 25, 2022)
16	Change in unrealized gains/losses on marketable debt securities, net of tax: Adjustment for net (gains)/losses realized and included in net income	95	Three Months Ended (June 25, 2022)
17	Change in unrealized gains/losses on marketable debt securities, net of tax: Total change in unrealized gains/losses on marketable debt securities	(3,055)	Three Months Ended (June 25, 2022)
18	Total other comprehensive income/(loss)	(2,803)	Three Months Ended (June 25, 2022)
19	Total comprehensive income	$16639	Three Months Ended (June 25, 2022)
20	Net income	$74039	Nine Months Ended (July 1, 2023)
21	Other comprehensive income/(loss): Change in foreign currency translation, net of tax	(494)	Nine Months Ended (July 1, 2023)
22	Change in unrealized gains/losses on derivative instruments, net of tax: Change in fair value of derivative instruments	(492)	Nine Months Ended (July 1, 2023)
23	Change in unrealized gains/losses on derivative instruments, net of tax: Adjustment for net (gains)/losses realized and included in net income	(1,854)	Nine Months Ended (July 1, 2023)
24	Change in unrealized gains/losses on derivative instruments, net of tax: Total change in unrealized gains/losses on derivative instruments	(2,346)	Nine Months Ended (July 1, 2023)
25	Change in unrealized gains/losses on marketable debt securities, net of tax: Change in fair value of marketable debt securities	1963	Nine Months Ended (July 1, 2023)
26	Change in unrealized gains/losses on marketable debt securities, net of tax: Adjustment for net (gains)/losses realized and included in net income	185	Nine Months Ended (July 1, 2023)
27	Change in unrealized gains/losses on marketable debt securities, net of tax: Total change in unrealized gains/losses on marketable debt securities	2148	Nine Months Ended (July 1, 2023)
28	Total other comprehensive income/(loss)	(692)	Nine Months Ended (July 1, 2023)
29	Total comprehensive income	$73347	Nine Months Ended (July 1, 2023)
30	Net income	$79082	Nine Months Ended (June 25, 2022)
31	Other comprehensive income/(loss): Change in foreign currency translation, net of tax	(1,102)	Nine Months Ended (June 25, 2022)
32	Change in unrealized gains/losses on derivative instruments, net of tax: Change in fair value of derivative instruments	1548	Nine Months Ended (June 25, 2022)
33	Change in unrealized gains/losses on derivative instruments, net of tax: Adjustment for net (gains)/losses realized and included in net income	(87)	Nine Months Ended (June 25, 2022)
34	Change in unrealized gains/losses on derivative instruments, net of tax: Total change in unrealized gains/losses on derivative instruments	1461	Nine Months Ended (June 25, 2022)
35	Change in unrealized gains/losses on marketable debt securities, net of tax: Change in fair value of marketable debt securities	(9,959)	Nine Months Ended (June 25, 2022)
36	Change in unrealized gains/losses on marketable debt securities, net of tax: Adjustment for net (gains)/losses realized and included in net income	140	Nine Months Ended (June 25, 2022)
37	Change in unrealized gains/losses on marketable debt securities, net of tax: Total change in unrealized gains/losses on marketable debt securities	(9,819)	Nine Months Ended (June 25, 2022)
38	Total other comprehensive income/(loss)	(9,460)	Nine Months Ended (June 25, 2022)
39	Total comprehensive income	$69622	Nine Months Ended (June 25, 2022)

Currently, I am testing different edge cases and working on other table formats like

	1	2	3
0
1	Title of each class	Trading symbol(s)	Name of each exchange on which registered
2	Common Stock, $0.00001 par value per share	AAPL	The Nasdaq Stock Market LLC
3	1.375% Notes due 2024	—	The Nasdaq Stock Market LLC
4	0.000% Notes due 2025	—	The Nasdaq Stock Market LLC
5	0.875% Notes due 2025	—	The Nasdaq Stock Market LLC
6	1.625% Notes due 2026	—	The Nasdaq Stock Market LLC
7	2.000% Notes due 2027	—	The Nasdaq Stock Market LLC
8	1.375% Notes due 2029	—	The Nasdaq Stock Market LLC
9	3.050% Notes due 2029	—	The Nasdaq Stock Market LLC
10	0.500% Notes due 2031	—	The Nasdaq Stock Market LLC
11	3.600% Notes due 2042	—	The Nasdaq Stock Market LLC

	1	2	3	4
0
1	Large accelerated filer	☒	Accelerated filer	☐
2	Non-accelerated filer	☐	Smaller reporting company	☐
3			Emerging growth company	☐

.. etc

[rozeappletree]

There are no separating blank columns for this GOOG 10-Q table suggesting "Empty rows in tables" is not a robust way to connect parent rows.

The table

will have a faulty output for independent rows.

7                                                             Current assets: Non-marketable securities    30492              As of December 31, 2022 
8                                                                 Current assets: Deferred income taxes     5261              As of December 31, 2022 
9                                                           Current assets: Property and equipment, net   112668              As of December 31, 2022 
10                                                               Current assets: Operating lease assets    14381              As of December 31, 2022 
11                                                               Current assets: Intangible assets, net     2084              As of December 31, 2022 
12                                                                             Current assets: Goodwill    28960              As of December 31, 202

Additionally, We cannot connect "Current assets:" to "Assets" because of no indentation or blank separating rows.