Make in to single row in exce;
Closed
HARY
-
Dec 18, 2015 at 12:08 PM
RayH
RayH
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
Related:
- Make in to single row in exce;
- How to convert multiple rows to single row in notepad++ ✓ - Forum - Excel
- Convert Single Column to Rows, into Matching Rows ✓ - Forum - Excel
- We can keep multiple version of a word document in a single file by using dash feature - Guide
- Paste data below the last used row - Guide
- Single beep in cpu - Guide
1 reply
RayH
Dec 18, 2015 at 02:09 PM
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
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.