Make in to single row in exce;
[Closed]
Report
HARY
-
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;
- Convert Single Column to Rows, into Matching Rows ✓ - Forum - Excel
- We can keep multiple versions of ms word document in a single file by using - How-To - Word
- Paste data below the last used row - How-To - Excel
- Single beep in cpu - How-To - Computer Architecture
- Excel repeat rows a specified number of times vba ✓ - Forum - Excel
1 reply
RayH
- Posts
- 122
- Registration date
- Tuesday August 31, 2010
- Status
- Contributor
- Last seen
- June 20, 2016
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.
