Forum Discussion
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.. Ideally, I'd like to move data from row 7 to 11 to new columns, then remove first row to look like this.. Is ...
vanessafvg
Community Champion
Community Championcan you share some data in text format?
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