challenge dynamic table issue

[ThankForYourHelp]

Hi there,

I am currently stuck at the design for the dynamic table I have.

How do I use the tool that will more dynamic solve the issues below?

Name	task	Layer 1	Layer 2	Total
test 1	1.test 21	1	2	3
test 1	2.test 22	2	3	5
test 1	3.test 23	3	4	7
test 1	4.test 24	4	5	9
test 1	5.test 25	5	6	11
test 1	6.test 26	6	7	13
test 2	1.test 21	7	8	15
test 2	2.test 22	8	9	17
test 2	3.test 23	9	10	19
test 2	4.test 24	10	11	21
test 2	5.test 25	11	12	23
test 2	6.test 26	12	13	25

my table will have more Layer column, and that Total column will include that new Layer column

the tool should automatically add those Layer columns in the tools

Those data in Layer are from my other Excel tabs.

Name	task	Layer 1	Layer 2	Layer 3	Total
test 1	1.test 21	1	2	3	6
test 1	2.test 22	2	3	4	9
test 1	3.test 23	3	4	5	12
test 1	4.test 24	4	5	6	15
test 1	5.test 25	5	6	7	18
test 1	6.test 26	6	7	8	21
test 2	1.test 21	7	8	9	24
test 2	2.test 22	8	9	10	27
test 2	3.test 23	9	10	11	30
test 2	4.test 24	10	11	12	33
test 2	5.test 25	11	12	13	36
test 2	6.test 26	12	13	14	39

[flying008]

Hi, @ThankForYourHelp 

FYI.

Input
	Name	task	Layer 1	Layer 2	Total
	test 1	1.test 21	1	2	3
	test 1	2.test 22	2	3	5
	test 1	3.test 23	3	4	7
	test 1	4.test 24	4	5	9
	test 1	5.test 25	5	6	11
	test 1	6.test 26	6	7	13
	test 2	1.test 21	7	8	15
	test 2	2.test 22	8	9	17
	test 2	3.test 23	9	10	19
	test 2	4.test 24	10	11	21
	test 2	5.test 25	11	12	23
	test 2	6.test 26	12	13	25
Output
RecordID	Name	task	Layer_1	Layer_2	Layer_3	Layer_4	Layer_5	Layer_6	Layer_7	Layer_8	Total
1	test 1	1.test 21	1	2	3	4	5	6	7	8	36
2	test 1	2.test 22	2	3	4	5	6	7	8	9	44
3	test 1	3.test 23	3	4	5	6	7	8	9	10	52
4	test 1	4.test 24	4	5	6	7	8	9	10	11	60
5	test 1	5.test 25	5	6	7	8	9	10	11	12	68
6	test 1	6.test 26	6	7	8	9	10	11	12	13	76
7	test 2	1.test 21	7	8	9	10	11	12	13	14	84
8	test 2	2.test 22	8	9	10	11	12	13	14	15	92
9	test 2	3.test 23	9	10	11	12	13	14	15	16	100
10	test 2	4.test 24	10	11	12	13	14	15	16	17	108
11	test 2	5.test 25	11	12	13	14	15	16	17	18	116
12	test 2	6.test 26	12	13	14	15	16	17	18	19	124