PQ - How to add columns from a list? each item in a list means a new column

[sandy666]

Source data

Financial Statement	Main Sub	Detailed Sub	2016	2017	2018	2019	2020	2021	2022	2023	2024	2025	2026
(1) Balance Sheet	[1-1] Non Current Assets	Fixed assets	14	11	6	47	44	49	5	99	65	33	122
(1) Balance Sheet	[1-1] Non Current Assets	Investments available for sale	1	30	33	39	29	7	7	11	5	66	111
(1) Balance Sheet	[1-1] Non Current Assets	intangible assets	34	26	17	3	46	13	23	3	(55)	99	100
(1) Balance Sheet	[1-1] Non Current Assets	Deferred tax assets	51	43	25	16	40	8	31	49	(115)	132	89
(1) Balance Sheet	[6-1] Balance Sheet Totals	Total non-current assets	100	110	81	105	159	77	41	33	(175)	165	78
(1) Balance Sheet	[2-1] Current Assets	Inventory	37	48	45	42	52	31	14	42	(235)	198	67
(1) Balance Sheet	[2-1] Current Assets	Cash and the like	36	2	22	38	10	50	8	66	(295)	231	56
(1) Balance Sheet	[2-1] Current Assets	Work in progress	32	24	5	35	41	4	55	999	(355)	264	45
(1) Balance Sheet	[2-1] Current Assets	Client	20	28	19	21	15	9	33	666	(415)	297	34
(1) Balance Sheet	[2-1] Current Assets	Prepaid expenses and other debit balances	53	12	54	18	23	27	44	777	(475)	330	23
(1) Balance Sheet	[6-1] Balance Sheet Totals	Total current assets	178	114	145	154	141	121	50	111	(535)	363	11
(1) Balance Sheet	[6-1] Balance Sheet Totals	total assets	278	224	226	259	300	198	300	500	(595)	396	222

• Rule1: =Table1[@2016]/$D$13
• Rule2: if additional column will be added to the source table , new column should appear in the result table automatically
• Rule3: if any of value will be blank - the result will be less by the number of empty cells
• Rule4: if last value will be 0 you'll get #NUM! error (remember, don't divide by zero!!!)
• Rule5: if any of value will be space or any text character- result will be blank column

see next post