How to generate csv through lines

Asked

Viewed 12 times

-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.

Upshot: inserir a descrição da imagem aqui

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.