Power Query to arrange 8 Different Headers as two different columns

[ashish128]

Dear All,

Greetings for the day!

I have a Table (BB Code Below)

I tried Power Query (Data From Range) and Achieved to have UnPivot the columns and then duplicate the Attribute and Value Columns but I do not know how to proceed further.

Kindly advice and guide.

Actual Data

Ashish-Dipika Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Regional Manager	Regional Manager id	Country	School	Division	Placement Cycle-Year	Target Core Q1	Target Core Q2	Target Core Q3	Target Core Q4	Actual Core Q1	Actual Core Q2	Actual Core Q3	Actual Core Q4
2	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	8	9	8	8	1	2	5	1
3	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	9	8	9	9	2	1	4	2
4	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	7	9	7	7	3	2	3	3
5	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	6	7	6	6	1	3	4	1
6	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	8	6	8	8	2	1	5	2
7	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	9	8	9	9	3	2	6	3
8	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	7	7	7	7	4	3	5	4
9	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	6	6	6	6	5	1	4	5
10	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	8	8	8	8	5	2	3	5
11	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	9	9	9	9	4	2	4	4
12	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	7	7	9	9	3	1	5	3
13	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	6	6	8	8	2	2	6	2
14	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	8	8	6	6	1	3	4	1
15	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	7	9	8	8	2	1	3	2
16	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	6	7	9	9	3	2	4	3
17	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	8	6	8	8	1	3	5	1
18	tony chris	0051e000005UFP7	India	Management	Mtech	2040	9	8	9	9	2	1	6	2
19	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	7	9	7	7	3	2	5	3
20	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	6	9	6	6	1	3	4	1
21	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	8	8	8	8	2	4	3	2
22	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	9	6	9	9	3	5	4	3
23	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	7	8	7	7	4	5	5	4
24	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	6	9	6	6	5	4	6	5
25	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	8	7	8	8	5	3	5	5
26	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	9	6	9	9	4	2	1	4
27	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	9	8	9	9	3	3	2	3
28	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	8	7	8	8	2	1	3	2
Sheet1

Achieved so far,

Ashish-Dipika Data.xlsx
	A	B	C	D	E	F	G	H
1	Regional Manager	Regional Manager id	Country	School	Division	Placement Cycle-Year	Attribute	Value
2	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q1	8
3	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q2	9
4	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q3	8
5	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q4	8
6	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Actual Core Q1	1
7	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Actual Core Q2	2
8	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Actual Core Q3	5
9	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Actual Core Q4	1
10	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Target Core Q1	9
11	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Target Core Q2	8
12	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Target Core Q3	9
13	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Target Core Q4	9
14	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Actual Core Q1	2
15	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Actual Core Q2	1
16	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Actual Core Q3	4
17	srivatsan N	0051e000005RVY4	Spain	Liberal Arts	Mtech	2025	Actual Core Q4	2
18	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Target Core Q1	7
19	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Target Core Q2	9
20	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Target Core Q3	7
21	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Target Core Q4	7
22	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Actual Core Q1	3
23	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Actual Core Q2	2
24	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Actual Core Q3	3
25	Ishu M	0051e000005S5wC	India	Engineering	B.Sc	2026	Actual Core Q4	3
26	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Target Core Q1	6
27	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Target Core Q2	7
28	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Target Core Q3	6
29	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Target Core Q4	6
30	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Actual Core Q1	1
31	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Actual Core Q2	3
32	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Actual Core Q3	4
33	Praba k	0051e000005Ga3i	South Africa	Management	B.A	2027	Actual Core Q4	1
34	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Target Core Q1	8
35	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Target Core Q2	6
36	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Target Core Q3	8
37	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Target Core Q4	8
38	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Actual Core Q1	2
39	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Actual Core Q2	1
40	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Actual Core Q3	5
41	Anandh N	0051e000005Qwvh	United Kingdom	Liberal Arts	M.sc	2028	Actual Core Q4	2
42	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Target Core Q1	9
43	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Target Core Q2	8
44	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Target Core Q3	9
45	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Target Core Q4	9
46	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Actual Core Q1	3
47	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Actual Core Q2	2
48	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Actual Core Q3	6
49	Dia A	0051e000005Sl8i	Spain	Engineering	B.Com	2029	Actual Core Q4	3
50	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Target Core Q1	7
51	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Target Core Q2	7
52	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Target Core Q3	7
53	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Target Core Q4	7
54	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Actual Core Q1	4
55	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Actual Core Q2	3
56	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Actual Core Q3	5
57	kishorkumartest P	0051e000005UKX1	India	Management	BBA	2030	Actual Core Q4	4
58	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Target Core Q1	6
59	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Target Core Q2	6
60	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Target Core Q3	6
61	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Target Core Q4	6
62	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Actual Core Q1	5
63	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Actual Core Q2	1
64	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Actual Core Q3	4
65	tony chris	0051e000005UFP7	South Africa	Liberal Arts	MBA	2031	Actual Core Q4	5
66	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Target Core Q1	8
67	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Target Core Q2	8
68	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Target Core Q3	8
69	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Target Core Q4	8
70	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Actual Core Q1	5
71	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Actual Core Q2	2
72	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Actual Core Q3	3
73	Rahul Registrar	0055h00000BBU9W	United Kingdom	Engineering	Btech	2032	Actual Core Q4	5
74	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Target Core Q1	9
75	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Target Core Q2	9
76	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Target Core Q3	9
77	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Target Core Q4	9
78	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Actual Core Q1	4
79	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Actual Core Q2	2
80	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Actual Core Q3	4
81	J.laxmi	0051e000005GtrD	Spain	Management	Mtech	2033	Actual Core Q4	4
82	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Target Core Q1	7
83	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Target Core Q2	7
84	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Target Core Q3	9
85	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Target Core Q4	9
86	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Actual Core Q1	3
87	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Actual Core Q2	1
88	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Actual Core Q3	5
89	srivatsan N	0051e000005RVY4	India	Management	B.Sc	2034	Actual Core Q4	3
90	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Target Core Q1	6
91	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Target Core Q2	6
92	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Target Core Q3	8
93	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Target Core Q4	8
94	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Actual Core Q1	2
95	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Actual Core Q2	2
96	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Actual Core Q3	6
97	Ishu M	0051e000005S5wC	South Africa	Liberal Arts	B.A	2035	Actual Core Q4	2
98	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Target Core Q1	8
99	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Target Core Q2	8
100	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Target Core Q3	6
101	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Target Core Q4	6
102	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Actual Core Q1	1
103	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Actual Core Q2	3
104	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Actual Core Q3	4
105	Praba k	0051e000005Ga3i	India	Engineering	M.sc	2036	Actual Core Q4	1
106	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Target Core Q1	7
107	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Target Core Q2	9
108	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Target Core Q3	8
109	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Target Core Q4	8
110	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Actual Core Q1	2
111	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Actual Core Q2	1
112	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Actual Core Q3	3
113	Anandh N	0051e000005Qwvh	South Africa	Management	B.Com	2037	Actual Core Q4	2
114	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Target Core Q1	6
115	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Target Core Q2	7
116	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Target Core Q3	9
117	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Target Core Q4	9
118	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Actual Core Q1	3
119	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Actual Core Q2	2
120	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Actual Core Q3	4
121	Dia A	0051e000005Sl8i	India	Liberal Arts	BBA	2038	Actual Core Q4	3
122	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Target Core Q1	8
123	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Target Core Q2	6
124	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Target Core Q3	8
125	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Target Core Q4	8
126	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Actual Core Q1	1
127	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Actual Core Q2	3
128	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Actual Core Q3	5
129	kishorkumartest P	0051e000005UKX1	South Africa	Engineering	Btech	2039	Actual Core Q4	1
130	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Target Core Q1	9
131	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Target Core Q2	8
132	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Target Core Q3	9
133	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Target Core Q4	9
134	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Actual Core Q1	2
135	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Actual Core Q2	1
136	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Actual Core Q3	6
137	tony chris	0051e000005UFP7	India	Management	Mtech	2040	Actual Core Q4	2
138	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Target Core Q1	7
139	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Target Core Q2	9
140	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Target Core Q3	7
141	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Target Core Q4	7
142	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Actual Core Q1	3
143	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Actual Core Q2	2
144	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Actual Core Q3	5
145	Rahul Registrar	0055h00000BBU9W	South Africa	Liberal Arts	B.Sc	2041	Actual Core Q4	3
146	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Target Core Q1	6
147	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Target Core Q2	9
148	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Target Core Q3	6
149	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Target Core Q4	6
150	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Actual Core Q1	1
151	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Actual Core Q2	3
152	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Actual Core Q3	4
153	J.laxmi	0051e000005GtrD	India	Engineering	B.A	2042	Actual Core Q4	1
154	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Target Core Q1	8
155	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Target Core Q2	8
156	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Target Core Q3	8
157	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Target Core Q4	8
158	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Actual Core Q1	2
159	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Actual Core Q2	4
160	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Actual Core Q3	3
161	srivatsan N	0051e000005RVY4	South Africa	Management	M.sc	2043	Actual Core Q4	2
162	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Target Core Q1	9
163	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Target Core Q2	6
164	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Target Core Q3	9
165	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Target Core Q4	9
166	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Actual Core Q1	3
167	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Actual Core Q2	5
168	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Actual Core Q3	4
169	Ishu M	0051e000005S5wC	India	Management	B.Com	2044	Actual Core Q4	3
170	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Target Core Q1	7
171	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Target Core Q2	8
172	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Target Core Q3	7
173	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Target Core Q4	7
174	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Actual Core Q1	4
175	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Actual Core Q2	5
176	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Actual Core Q3	5
177	Praba k	0051e000005Ga3i	South Africa	Liberal Arts	BBA	2045	Actual Core Q4	4
178	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Target Core Q1	6
179	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Target Core Q2	9
180	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Target Core Q3	6
181	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Target Core Q4	6
182	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Actual Core Q1	5
183	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Actual Core Q2	4
184	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Actual Core Q3	6
185	Anandh N	0051e000005Qwvh	India	Engineering	MBA	2046	Actual Core Q4	5
186	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Target Core Q1	8
187	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Target Core Q2	7
188	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Target Core Q3	8
189	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Target Core Q4	8
190	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Actual Core Q1	5
191	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Actual Core Q2	3
192	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Actual Core Q3	5
193	Dia A	0051e000005Sl8i	South Africa	Management	Btech	2047	Actual Core Q4	5
194	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Target Core Q1	9
195	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Target Core Q2	6
196	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Target Core Q3	9
197	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Target Core Q4	9
198	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Actual Core Q1	4
199	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Actual Core Q2	2
200	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Actual Core Q3	1
201	kishorkumartest P	0051e000005UKX1	India	Liberal Arts	Mtech	2048	Actual Core Q4	4
202	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Target Core Q1	9
203	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Target Core Q2	8
204	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Target Core Q3	9
205	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Target Core Q4	9
206	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Actual Core Q1	3
207	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Actual Core Q2	3
208	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Actual Core Q3	2
209	tony chris	0051e000005UFP7	South Africa	Engineering	B.Sc	2049	Actual Core Q4	3
210	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Target Core Q1	8
211	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Target Core Q2	7
212	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Target Core Q3	8
213	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Target Core Q4	8
214	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Actual Core Q1	2
215	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Actual Core Q2	1
216	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Actual Core Q3	3
217	Rahul Registrar	0055h00000BBU9W	India	Management	B.A	2050	Actual Core Q4	2
Table1

Desired Data Format

Ashish-Dipika Data.xlsx
	A	B	C	D	E	F	G	H	I	J
32	Regional Manager	Regional Manager id	Country	School	Division	Placement Cycle-Year	Target Q	Value	Actual Q	Value
33	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q1	8	Actual Core Q1	1
34	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q2	9	Actual Core Q2	2
35	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q3	8	Actual Core Q3	5
36	J.laxmi	0051e000005GtrD	United Kingdom	Management	Btech	2024	Target Core Q4	8	Actual Core Q4	1
Sheet1

 

[ExcelToDAX]

Assuming your table name is Table1... how about:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Regional Manager", type text}, {"Regional Manager id", type text}, {"Country", type text}, {"School", type text}, {"Division", type text}, {"Placement Cycle-Year", Int64.Type}, {"Target Core Q1", Int64.Type}, {"Target Core Q2", Int64.Type}, {"Target Core Q3", Int64.Type}, {"Target Core Q4", Int64.Type}, {"Actual Core Q1", Int64.Type}, {"Actual Core Q2", Int64.Type}, {"Actual Core Q3", Int64.Type}, {"Actual Core Q4", Int64.Type}}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Regional Manager", "Regional Manager id", "Country", "School", "Division", "Placement Cycle-Year"}, "Attribute", "Value"),
    #"Duplicated Column" = Table.DuplicateColumn(#"Unpivoted Columns", "Attribute", "Attribute - Copy"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column", "Attribute - Copy", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, true), {"Attribute - Copy.1", "Attribute - Copy.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Attribute - Copy.1", type text}, {"Attribute - Copy.2", type text}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Attribute - Copy.2"}),
    #"Pivoted Column" = Table.Pivot(#"Removed Columns", List.Distinct(#"Removed Columns"[#"Attribute - Copy.1"]), "Attribute - Copy.1", "Value", List.Sum),
    MainTable = Table.Sort(#"Pivoted Column",{{"Attribute", Order.Ascending}}),
    #"Filtered Rows" = Table.SelectRows(MainTable, each ([Target Core] <> null)),
    #"Removed Columns1" = Table.RemoveColumns(#"Filtered Rows",{"Actual Core"}),
    #"Sorted Rows" = Table.Sort(#"Removed Columns1",{{"Regional Manager", Order.Ascending}, {"Regional Manager id", Order.Ascending}, {"Country", Order.Ascending}, {"School", Order.Ascending}, {"Division", Order.Ascending}, {"Placement Cycle-Year", Order.Ascending}, {"Attribute", Order.Ascending}}),
    TargetCore = Table.AddIndexColumn(#"Sorted Rows", "Index", 0, 1, Int64.Type),
    Custom1 = MainTable,
    #"Filtered Rows1" = Table.SelectRows(Custom1, each ([Actual Core] <> null)),
    #"Removed Columns2" = Table.RemoveColumns(#"Filtered Rows1",{"Target Core"}),
    #"Sorted Rows1" = Table.Sort(#"Removed Columns2",{{"Regional Manager", Order.Ascending}, {"Regional Manager id", Order.Ascending}, {"Country", Order.Ascending}, {"School", Order.Ascending}, {"Division", Order.Ascending}, {"Placement Cycle-Year", Order.Ascending}, {"Attribute", Order.Ascending}}),
    ActualCore = Table.AddIndexColumn(#"Sorted Rows1", "Index", 0, 1, Int64.Type),
    #"Merged Queries" = Table.NestedJoin(ActualCore, {"Index"}, TargetCore, {"Index"}, "Table1", JoinKind.LeftOuter),
    #"Expanded Table1" = Table.ExpandTableColumn(#"Merged Queries", "Table1", {"Target Core"}, {"Table1.Target Core"}),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Expanded Table1", "Attribute", "Attribute - Copy"),
    #"Replaced Value" = Table.ReplaceValue(#"Duplicated Column1","Actual","Target",Replacer.ReplaceText,{"Attribute - Copy"}),
    #"Renamed Columns" = Table.RenameColumns(#"Replaced Value",{{"Attribute - Copy", "Target Q"}, {"Table1.Target Core", "Target Value"}, {"Attribute", "Actual Q"}, {"Actual Core", "Actual Value"}}),
    #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns",{"Index"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns3",{"Regional Manager", "Regional Manager id", "Country", "School", "Division", "Placement Cycle-Year", "Target Q", "Target Value", "Actual Q", "Actual Value"}),
    #"Filtered Rows2" = Table.SelectRows(#"Reordered Columns", each ([Regional Manager] = "J.laxmi") and ([Country] = "United Kingdom"))
in
    #"Filtered Rows2"

 

[alex78]

Like this ?

let
    fx = (x,y,z)=> Record.SelectFields(x,List.Select(y, (w)=> Text.Contains(w,z))),
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    ColName = {List.Select(Table.ColumnNames(Source), (x) => not Text.Contains(x,"Core"))} & {{"Target Q", "Value", "Actual Q", "Value2"}},
    Process = Table.AddColumn(Source, "x", each let x =fx(_,Table.ColumnNames(Source),"Core") in  
              Table.FromColumns(Table.ToColumns(Record.ToTable(fx(x,Record.FieldNames(x) ,"Target"))) &
              Table.ToColumns(Record.ToTable(fx(x,Record.FieldNames(x) ,"Actual"))), ColName{1})),
    Result = Table.SelectColumns(Table.ExpandTableColumn(Process, "x", ColName{1}, ColName{1}), List.Union(ColName))
in
    Result

 

[JGordon11]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    cols = {"Regional Manager", "Regional Manager id", "Country", "School", "Division", "Placement Cycle-Year"},
    unpivot = Table.UnpivotOtherColumns(Source, cols, "Attribute", "Value"),
    addQTR = Table.AddColumn(unpivot, "Qtr", each Number.From(Text.End([Attribute],1))),
    removeQ = Table.TransformColumns(addQTR, {{"Attribute", each Text.BeforeDelimiter(_, " ", 1), type text}}),
    group = Table.Group(removeQ, cols & {"Qtr"}, {{"All", each Table.Pivot(_, {"Target Core", "Actual Core"}, "Attribute", "Value")}}),
    combine = Table.Combine(group[All])
in
    combine

 

[AlienSx]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    cols = Table.ColumnNames(Source),
    target = List.Buffer(List.Range(cols, 6, 4)), 
    actual = List.Buffer(List.Range(cols, 10, 4)),
    to_list = Table.ToList(
        Source, 
        (w) => List.TransformMany(
            {w}, 
            (x) => List.Zip({target, List.Range(x, 6, 4), actual, List.Range(x, 10, 4)}),
            (x, y) => List.FirstN(x, 6) & y
        )
    ), 
    to_table = Table.FromList(
        List.Combine(to_list), 
        (x) => x, 
        List.FirstN(cols, 6) & {"Target Q", "Target Value", "Actual Q", "Actual Value"}
    )
in
    to_table

 

[ashish128]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    cols = {"Regional Manager", "Regional Manager id", "Country", "School", "Division", "Placement Cycle-Year"},
    unpivot = Table.UnpivotOtherColumns(Source, cols, "Attribute", "Value"),
    addQTR = Table.AddColumn(unpivot, "Qtr", each Number.From(Text.End([Attribute],1))),
    removeQ = Table.TransformColumns(addQTR, {{"Attribute", each Text.BeforeDelimiter(_, " ", 1), type text}}),
    group = Table.Group(removeQ, cols & {"Qtr"}, {{"All", each Table.Pivot(_, {"Target Core", "Actual Core"}, "Attribute", "Value")}}),
    combine = Table.Combine(group[All])
in
    combine

Dear @JGordon11 ,

Thanks for your solution. What @alex78 gave was the solution I was looking for but what you gave was solution of my next step which I had planned so Thank you for guiding me in advance.