Make in to single row in exce;

Closed
HARY - Dec 18, 2015 at 12:08 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Dec 18, 2015 at 02:09 PM
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 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Dec 18, 2015 at 02:09 PM
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.
0