Make in to single row in exce;
Closed
HARY
-
18 Dec 2015 à 12:08
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 18 Dec 2015 à 14:09
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 18 Dec 2015 à 14:09
Related:
- Make in to single row in exce;
- How to delete a row in word - Guide
- Saints row 2 cheats - Guide
- Single sim samsung keypad mobile ✓ - Phones, PDA & GPS Forum
- Samsung gt-e1200 Password unlock ✓ - Phones, PDA & GPS Forum
- Saints row pc download - Download - Action and adventure
1 response
RayH
Posts
122
Registration date
Tuesday 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
18 Dec 2015 à 14:09
18 Dec 2015 à 14:09
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.
