Headers and values not top down but two columns side by side in multiple files

[adelmonte]

Hi all,

I need to load column names and values which are side by side and not top down structure from multiple files.

Any idea how I can solve my issue?

Sample1

Sample2

I arrived till here

Desired outcome

Sample Files

https://drive.google.com/file/d/1a4V7rgQijBHgZV2Prodfab0g_ufAnd5d/view?usp=sharing

Thanks,

Alex

[adelmonte · Accepted solution]

I found solution

https://drive.google.com/file/d/1-KMFcDmPpWQ6x2Q9vcBz3OZN822LAcrI/view?usp=sharing

Thanks anyway