Create Fields from folder names

[AmCh]

Hello All,

A. First step

I want to (1.) generate fields and (2.) name them as follow:

* I have a folder AB11  underthis path : C:\AB1\ AB11 containing  folders  01_AB111 and 02_AB112

--> (2.) Names of the fields should be AB111 and AB112

** 01_AB111 contains now Excel files named 01_v1111 and 02_v1112

*** 02_AB112 doesn't contain Excel files 

--> (1.) Values of field AB111  should be v1111 and v1112

--> (1.) Since 02_AB112 does not contain data files, the field AB112 has not to be created.

Output

AB111

v1111

v1112

B. Second step

* Excel files (e.g. 01_v1111 and 02_v1112) are structured as follow:

01_v1111

A	B	C
1	2	3
2	1	4

02_v1112

A	B	C
1	2	3
5	8	9
0	11	7

--> I want to generate the following table named AB111 :

Variants_AB111	A_AB111	B_AB111	C_AB111
01_v1111	1	2	3
01_v1111	2	1	4
02_v1112	1	2	3
02_v1112	5	8	9
02_v1112	0	11	7

Any help please?

Thanks in advance.

Beste regards,

Amor