split few rows in separate column

Question

Hi All,

Pls help to look into below query.

Is it possible to split few rows or cells from from a column and display it in two columns like below:

Regards

Nitish

Input Customer NameSushant RanjanNancy KhannaJohn MickDavid DubisDavid SharmaAlbert NicosNia SharmaNuria Genebat

Output   Customer NameCustomer NameSushant RanjanNancy KhannaDavid DubisJohn MickAlbert NicosDavid SharmaNuria GenebatNia Sharma

grazitti_sapna · Accepted Answer

Hi @NitishSrivastava , the solution is applicable for this particular dataset.

If this is what you are looking for kindly mark this post as solution.

Thanks.

philipmannering · Accepted Answer

Hi Nitish,

A few ways to do this, but the simplest is using the Make Columns Tool. See configuration in screenshot below,

Thanks,

Philip