Hi,

In my website, I have created a folder strucre, which has files in the innermost folders only.

Its is like this

Folders

LEvel 1 folders: US, UK, Japan

Level 2 folders(in each of leve l1 folders): People, Leaders

Level 3: Individual profile

Now I want the export the file report to excel where I get my innermost file name in 1st column of sheet  then the upper folder name in second then the top most folder name in 3rd colum.

So my A column should have PRofile of people, B colum should tell me if it was in people or leaders folder and C colum shoud reflect the country.

Please help me its urgent