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
djp979
New Member

How do I move data from specific rows of a column into another column?

The csv files that I pull are not formatted properly, something like this..

djp979_0-1687467579903.png

Ideally, I'd like to move data from row 7 to 11 to new columns, then remove first row to look like this..

djp979_1-1687467719283.png

Is there a way to do this?

2 REPLIES 2
vanessafvg
Super User
Super User

can you share some data in text format?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




a,b,c,d,e
,first,second,third,fourth
L,8,-2,4,6
C,9,-4,2,7
R,7,-5,3,7
,,,,
a2,b2,c2,d2
,first(2),second(2),third(2)
L,4,-3,5
C,7,0,3
R,2,-1,3

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.