Need help to create an excel macro (Combine columns)
Solved/Closed
sudiptabiswasmacro
Blocked Profile - Aug 20, 2013 at 11:27 AM
- Posts
- 4
- Registration date
- Saturday August 17, 2013
- Status
- Member
- Last seen
- September 23, 2013
Blocked Profile - Aug 20, 2013 at 11:27 AM
Related:
- Need help to create an excel macro (Combine columns)
- Excel Macro: combine selected rows ✓ - Forum - Excel
- Excel macro search column for value - Guide
- Excel Macro - Multiple Columns Into One ✓ - Forum - Excel
- Excel Macro - Dynamic Column Selection ✓ - Forum - Excel
- Excel macro delete columns based on header ✓ - Forum - Excel
3 replies
Good Afternoon...
A Formula (not macro) would be the following....
=CONCATENATE(A1,A2)
//ark
-Contributor
A Formula (not macro) would be the following....
=CONCATENATE(A1,A2)
//ark
-Contributor
thanks 4 ur reply. Issue not resolved.
But I may be not able to make u understand what I want is. Let me try once again.
I need to put n(n is count of rows) numbers of accounts in Col A ( suppose 1,2,3,....).
I need to put n(n is count of rows) numbers of stocks in Col B ( suppose A,B,C...).
Now I need macro for out put in Col C like:_
1A(in C2 cell)
1B(in C3 cell)
1C(in C4 cell)
2A(in C5 cell)
2B(in C6 cell)
2C(in C7 cell)
3A(in C8 cell)
3B(in C9 cell)
3C(in C10 cell)
and so on.
Pls try to answer if possible.
Regards
But I may be not able to make u understand what I want is. Let me try once again.
I need to put n(n is count of rows) numbers of accounts in Col A ( suppose 1,2,3,....).
I need to put n(n is count of rows) numbers of stocks in Col B ( suppose A,B,C...).
Now I need macro for out put in Col C like:_
1A(in C2 cell)
1B(in C3 cell)
1C(in C4 cell)
2A(in C5 cell)
2B(in C6 cell)
2C(in C7 cell)
3A(in C8 cell)
3B(in C9 cell)
3C(in C10 cell)
and so on.
Pls try to answer if possible.
Regards
=concatenate(a2,b2) in cell c2 is correct. If you just cut and pasted it into your sheet thinking it was going to work then that is why.
Your scope has changed from the origianl post of:
Col A Col B Col C
Input Input Out Put
100114 0001FVT1444 1001140001FVT1444
...as the above was the inital example with the need of:
"For each cell value in col A, need to be combined with all the cell values in col B."
So, you can use concatenate as above, or use the & operator as in:
=A2&B2
//ark
-Contributor
Your scope has changed from the origianl post of:
Col A Col B Col C
Input Input Out Put
100114 0001FVT1444 1001140001FVT1444
...as the above was the inital example with the need of:
"For each cell value in col A, need to be combined with all the cell values in col B."
So, you can use concatenate as above, or use the & operator as in:
=A2&B2
//ark
-Contributor
