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
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Dec 18, 2015 at 02:09 PM
Related:
- Make in to single row in exce;
- Saints row 2 cheats - Guide
- How to delete a row in a table in word - Guide
- Which key is used to make multiple line in a single cell - Guide
- Single sim samsung keypad mobile ✓ - Phones, PDA & GPS Forum
- Samsung E1200Y Phone Code Reset - Phones, PDA & GPS Forum
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
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.
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.