Split the column into multiple columns with the same data

[jmedidi]

looking to split the column A which contain the string " FFFDDDSSS"  into 4 columns with the same string value. Is there any easy way to do it ?

[atcodedog05 · Accepted solution]

Hi @jmedidi 

You can use the formula tool to create columns and replicate data like below.

Hope this helps : )

[DawnDuong]

hi @jmedidi 

You can also use the Generate Row Tool and select "Update existing column" option to generate the same content N times as needed. Then you can use Cross-Tab Tool to convert the rows into columns.

Dawn.