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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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