Data Transporting & text to column by macro

[nur2544]

Dear All, I am facing problem while text to column as CELL A1 data is not transposing format .here is an example.

CELL A1
2/10/2018
16-Feb-18
22-Feb-18
26-Feb-18

I want like below

CELL A1 CELL B1 CELL C1 CELL D1
2/10/2018 16-Feb-18 22-Feb-18 26-Feb-18

Please find the attached file where sheet "input" is my actual data and sheet "output" is my desire data.

[mike7952]

Something like this should work

Please Login or Register  to view this content.

[nur2544]

Hi Mike, It works perfectly, I appreciated your nice job, it will help me a lots, thanks for your valuable time in this regards.