Copy n Paste Filtered Data

[GMC The Macro Man]

Hi everyone, I hope you are all well.
I have a report from a school database that details the students grades for the subjects they are sitting. There are 25 subjects and each student will select at least 5 from this list and then they will be allocated a National Level (Nat Level 3 to 7) depending on their skill level. There is a teachers name and then their grade.
The database is exported as an XLSX file and looks like the excerpt below which is the data is displayed in row form , Left to Right. What I am trying to achieve is to MERGE the subjects into one GROUP of columns for each of the subjects.
I tried copy to filter the data and copy paste, and copy fill but that obviously doesn't work. Would this be a better done as a Power Query?
If you see the TWO Tables I have put together as examples, The 1st is what I get from the export and the 2nd one is how I would like it to look (just to remind you that I have 25 subjects in the report)
The school has over 500 children each with unique ID's

Any help would be greatly appreciated
Thanks
George

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1				Art & Design (Nat 4)			Art & Design (Nat 5)			Art & Design (Nat 6)			English (Nat 4)			English (Nat 5)			English (Nat 6)			English (Nat 7)
2	ID Number	Full Name	Reg Class	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade
3	P12345	Summer Kerr	4C	Nat 4	Miss Smith	5										Nat 5	Mr Orange	2
4	P12346	Megan Airlie	4B				Nat 5	Mr Black	6				Nat 4	Miss Blue	4
5	P12347	Sarah Blair	4C	Nat 4	Miss Smith	5										Nat 5	Mr Orange	2
6	P12348	Tehya Bommer	4C	Nat 4	Miss Smith	3							Nat 4	Miss Blue	4
7	P12349	Hannah Callaghan	4D							Nat 6	Mrs White	3	Nat 4	Miss Blue	1
8	P12350	Ava Currie	4E				Nat 5	Mr Black	6							Nat 5	Mr Orange	2
9	P12351	Amiee Fraser	4E				Nat 5	Mr Black	7													Nat 7	Mr Green	3
10	P12352	Cailin Gilliland	4A							Nat 6	Mrs White	5							Nat 6	Mrs Brown	4
11	P12353	Christopher Grant	4D	Nat 4	Miss Smith	3							Nat 4	Miss Blue	3
12	P12354	Sophie Grigor	4D										Nat 4	Miss Blue	3
13	P12355	Rachael Johnson	4B
14	P12356	Emily Livingstone	4F	Nat 4	Miss Smith	4							Nat 4	Miss Blue	6
15	P12357	Katie Maloney	4B																Nat 6	Mrs Brown	7
16	P12358	Emma McDonald	4C							Nat 6	Mrs White	5										Nat 7	Mr Green	5
17	P12359	Hannah McDougall	4C										Nat 4	Miss Blue	3
18	P12360	Corey McIlduff	4E				Nat 5	Mr Black	4				Nat 4	Miss Blue	8
19	P12361	Danielle McMahon	4F							Nat 6	Mrs White	8				Nat 5	Mr Orange	6
Sheet1

Book1
	A	B	C	D	E	F	G	H	I
21				Art & Design			English
22	ID Number	Full Name	Reg Class	Nat Level	Teacher	Grade	Nat Level	Teacher	Grade
23	P12345	Summer Kerr	4C	Nat 4	Miss Smith	5	Nat 5	Mr Orange	2
24	P12346	Megan Airlie	4B	Nat 5	Mr Black	6	Nat 4	Miss Blue	4
25	P12347	Sarah Blair	4C	Nat 4	Miss Smith	5	Nat 5	Mr Orange	2
26	P12348	Tehya Bommer	4C	Nat 4	Miss Smith	3	Nat 4	Miss Blue	4
27	P12349	Hannah Callaghan	4D	Nat 6	Mrs White	3	Nat 4	Miss Blue	1
28	P12350	Ava Currie	4E	Nat 5	Mr Black	6	Nat 5	Mr Orange	2
29	P12351	Amiee Fraser	4E	Nat 5	Mr Black	7	Nat 7	Mr Green	3
30	P12352	Cailin Gilliland	4A	Nat 6	Mrs White	5	Nat 6	Mrs Brown	4
31	P12353	Christopher Grant	4D	Nat 4	Miss Smith	3	Nat 4	Miss Blue	3
32	P12354	Sophie Grigor	4D				Nat 4	Miss Blue	3
33	P12355	Rachael Johnson	4B
34	P12356	Emily Livingstone	4F	Nat 4	Miss Smith	4	Nat 4	Miss Blue	6
35	P12357	Katie Maloney	4B				Nat 6	Mrs Brown	7
36	P12358	Emma McDonald	4C	Nat 6	Mrs White	5	Nat 7	Mr Green	5
37	P12359	Hannah McDougall	4C	Nat 5	Mr Black	4	Nat 4	Miss Blue	3
38	P12360	Corey McIlduff	4E				Nat 4	Miss Blue	8
39	P12361	Danielle McMahon	4F	Nat 6	Mrs White	8	Nat 5	Mr Orange	6
Sheet1

 

[GMC The Macro Man]

- I found this on YouTube - thanks to Chris Menard
It allows me to merge all the subjects Nat Levels in to individual groups by using the "SKIP BLANKS" when pasting.
I only do this report 3 times a year so it will probably take me about an hour to go through the 25 subjects. Its not ideal but it will get me through.

I would still love to find a quicker way to do this if anyone can help
thanks for looking