Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adelmonte
Resolver I
Resolver I

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

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

adelmonte_1-1679391023634.png

Sample2

adelmonte_5-1679391376112.png

I arrived till here

adelmonte_3-1679391106865.png

adelmonte_2-1679391085466.png

 

Desired outcome

adelmonte_4-1679391307762.png

 

Sample Files

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

Thanks,

Alex

 

1 ACCEPTED SOLUTION
adelmonte
Resolver I
Resolver I
1 REPLY 1
adelmonte
Resolver I
Resolver I

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.