Transpose tables

[DianaPur]

Hi, I have a lot of files in this format (see attached). I want to see all data in one excel files. I am trying to do with transpose, but it puts all files in next rows, not one below other. After that I am trying to use INDEX and Pivot but it doesn't make the data easy to proccess ( see another attached file).

Can somebody give me an idea how to do it?

Thanks a lot in advance!

Diana

 

[Rudi]

This is more a sample than a solution.
It's just a different way of going about modifying multiple files in a folder.

1. Edit the "Path" variable in the query to point to the folder which contains all your files.
2. Then modify the query called: "Transform Sample File from Test". (This query represents one of the files in your folder. The changes you make to this single query will iterate through to the main query called: "Test")

There is probably still a lot of work to do in the Sample File, so give it a go and see if you take it further...

File attached: View attachment Diana.xlsx

 

[DianaPur]

Thank you Rudi