unpivoting from a folder for automation

[Chrisjr]

Hello,

I am getting excel files from a folder in the goal to automate the transformation on each files.

The structure of each files is the same. See link: https://drive.google.com/drive/folders/1e_0xaOvVmSRsGXFk4m5Lt5rLE_ZH05qS?usp=sharing

The sheet to transform from each file would always be sheet1. 

The app with the loaded excel files is also under the link.  ( when I invoke the sheet1, I get an error) 

However, the names of the first row (which is for the bike name) can change (instead of having BikeAAAA it could be BikeCCCCC).

I am trying to get the following:

ReferenceBike (which will always be the column b in each excel. )	Bike	Bike Type	indexType	Value
BikeAAAA	BikeBCB	EngineB	Index list price	1
BikeAAAA	BikeDC
BikeAAAA
BikeAAAA
BikeAAAA
BikeA
BikeA
BikeA
BikeA

Can someone help me ?

Thanks

[Chrisjr]

Hi @v-henryk-mstf 

yes of course. Here is the link: https://drive.google.com/drive/folders/1e_0xaOvVmSRsGXFk4m5Lt5rLE_ZH05qS?usp=sharing

thank you 

[v-henryk-mstf]

Hi @Chrisjr ,

The link you provided can not open. Can you reshare it again?

Looking forward to your reply.

Best Regards,
Henry