Copying + Transpond Data in One Step

[excelhelp1423]

Hello,

i have a problem, that i have a lot of Information, that is presented in a vertical way in cells. My wish is that the raw data is copied and transponded in one step if it is possible, because i want to have the oportunnity to "data cut" to filter my input. That is not possible, if the data is presented in a vertical way, only if i split it into columns and then the possibility is given to filter the data. I can copy every vertical column into the horizontal way, but to make it more flow, it would be better if the data is directly copied and transponded, without me having to actualy manualy copy it into the horizontal way. Screenshots attached, i wanted to post the file itself, but it . I read, that there is a possibility to solve it with an query-database, but i didnt understand it at all haha

Thanks in advance

 

[excelhelp1423]

Copy-Transpond.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	Spalte1	Spalte2	Spalte3	Spalte4	Spalte5	Spalte6	Spalte7	Spalte8	Spalte9	Spalte10	Spalte11	Spalte12	Spalte13	Spalte14	Spalte15
4	1	x		x
5	2	x		x
6	3	x		x
7	4	x		x
8	5	x		x
9	6	x		x
10	7	x		x
11	8	x		x
12	9	x		x
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29	-
30	-
31	-
32	-
33	-
34	-
35	-
36	-
37	-
38	-
39	-
40	-
41	-
42	-
1

 

[excelhelp1423]

Copy-Transpond.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	1	2	3	4	5	6	7	8	9	Spalte1	Spalte2	Spalte3	Spalte4	Spalte5	Spalte6
3	x	x	x	x	x	x	x	x	x
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28	-
29	-
30	-
31	-
32	-
33	-
34	-
35	-
36	-
37	-
38	-
39	-
40	-
41	-
2