Make in to single row in exce;

[Closed]
Report
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
Hello,

I HAVE EXCEL DATA IN THE BELOW FORMAT

93456787 BR129 11-10-2011 12:34:00 PM
93456787 BR140 16-9-2012 11:24:00 PM
93456787 BR150 6-7-2014 12:34:00 PM
93456787 BR158 11-6-2015 12:34:00 PM

i want out put like in excel
93456787 BR129 11-10-2011 12:34:00 PM BR140 16-9-2012 11:24:00 PM BR150 6-7-2014 12:34:00 PM BR158 11-6-2015 12:34:00 PM

can any one help please its urgent

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
With your data in columns A, B and C.
In D1, =CONCATENATE(A1,B1,C1)
Then in D2: =CONCATENATE(D1,A2,B2,C2)

copy this formula down through the rest of the rows.
Each result will get longer the further you go down.

Its not pretty but its quick and easy.