split few rows in separate column

[NitishSrivastava]

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 Name

Sushant Ranjan

Nancy Khanna

John Mick

David Dubis

David Sharma

Albert Nicos

Nia Sharma

Nuria Genebat

Output
Customer Name	Customer Name
Sushant Ranjan	Nancy Khanna
David Dubis	John Mick
Albert Nicos	David Sharma
Nuria Genebat	Nia Sharma

[grazitti_sapna · Accepted solution]

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 solution]

Hi Nitish,

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

Thanks,

Philip

[NitishSrivastava]

Thanks a ton @PhilipMannering

It is helpful.

Regards

Nitish 

[NitishSrivastava]

Thanks .@grazitti_sapna

This works.

Regards

Nitish Srivastava