-1
I need to generate one. csv through a row I’ve managed to turn into a column, but I’m not able to break this column into other columns.
Example: I had the following information in 4 tabs of my spreadsheet: A,A,A;B,B,B;C,C,C;D,D,D,D.
Where each: ; is the division of my columns and where you have: , needed to be a new row of a specific column. so I did the replacement and break row
coluna.replace(",", ";\n")
So I have all the letters with ; n at the end of the string. But I needed to break the rows by columns to separate the letters and have the following result:
Letter A | Letter B | Letter C | Letter D |
---|---|---|---|
To | B | C | D |
To | B | C | D |
To | B | C | D |
Today I have each letter in a variable and when I try to realize the concreteness is not right because the concatenation is starting after the last position. Example the first letter B is concatenating after the last letter A and I needed it to concatenate in the first position ie with the first letter A.
Hello, Try one more replace(';', '; n').
– Werley Mendes Andrade