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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Converting repeating rows into columns

I have a table which looks like this - (just giving an example and this repeats for multiple times)

 

A.1Order no123
A.2ProductLaptop
A.3Revenue135
A.4Margin25
A.1Order no234
A.2ProductServer
A.3Revenue200
A.4Margin25
A.1Order no456
A.2ProductLaptop
A.3Revenue135
A.4Margin2

 

I would like it to be transformed into this - 

 

A.1A.2A.3A.4
Order noProductRevenueMargin
123Laptop13525
234Server20025
456Laptop1352

 

Can you help me with the steps to achieve this while I am transforming data? 

1 ACCEPTED SOLUTION
3 REPLIES 3
dannytan111289
Frequent Visitor

Hi,

 

Did you have any answer to your case? if you have the solution, do u mind to put it here? Thanks

Hi,

 

I don't really understand the link that you gave. If we do transpose directly, the result would be 12 columns of A1-A4 repeatedly. Any idea how to make it became 4 columns and multiple rows ? Because i have the same problem. Thanks sir

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.