LinkBack URL
About LinkBacks
I've multiple columns of data which I want to put in to 1 single column.
EX: Columns A,B,C Data is appended in to D.
A B C D
1 5 9 1
2 6 10 2
3 7 11 3
4 8 12 4
13 5
14 6
7
8
9
10
11
12
13
14
I've multiple columns of data which I want to put in to 1 single column.
EX: Columns A,B,C Data is appended in to D.
A B C D
1 5 9 1
2 6 10 2
3 7 11 3
4 8 12 4
13 5
14 6
7
8
9
10
11
12
13
14
concatenate can combine cells into one cell. if you wanted to combine A1 b1 and c1 with commas in between the numbers your fromula would look something like this---
=CONCATENATE(A1,",",B1,",",C1)
I hope this helps
Sorry my paste wasn't correct. Pls find the attached Pic.
a.jpg
Can you show me what you want to see in cell D2? Also will column D:D always count be counting up one at a time?
Ok seems like i confused you..Ignore the numbers, What I exactly want is.. Column D should have Column A values followed by Column B then followed by Column C.. Basically Combine 3 columns one after another in to 1 single column. Hope i made it clear.
I may be very confused, and I am sorry if I am not getting it, but I still think the concatenate command from my 1st post should work. If you don't want the commas just don't but in the extra ",". All the information from a,b,and c will appear together in cell d.
Hi and welcome to the forum
If you want to combine them, then maybe just =A1&B1&C1
If you want to ADD them, then =A1+B1+C1 or =sum(A1:C1)
if that is not what you want, please upload a sample file, shows examples of your data, and what your expected outcome would be.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I already attached a screenshot..am attaching a excel file as well.. A, B , C are existing columns... Currently Values in Column D are copy pasted by me.. instead of copy paste i need a formula to achieve this
It can easily be done by a macro code. Are you comfortable using a macro, or you want to stick with formula?
Hi,
Assuming your data is in columns A-C, with no blank entries in any of these columns, enter this array formula (important that you know how to enter this type of formula in Excel) in D1 and copy down as required:
=INDEX(INDEX(A:C,,MATCH(TRUE,MMULT(--(ROW(INDIRECT("1:"&COLUMNS(A:C)))>=TRANSPOSE(ROW(INDIRECT("1:"&COLUMNS(A:C))))),SUBTOTAL(2,OFFSET(A:A,,ROW(INDIRECT("1:"&COLUMNS(A:C)))-1,,)))>=ROWS($1:1),0)),IFERROR(1+ROWS($1:1)-LOOKUP(ROWS($1:1),1+MMULT(--(ROW(INDIRECT("1:"&COLUMNS(A:C)))>=TRANSPOSE(ROW(INDIRECT("1:"&COLUMNS(A:C))))),SUBTOTAL(2,OFFSET(A:A,,ROW(INDIRECT("1:"&COLUMNS(A:C)))-1,,)))),ROWS($1:1)))
Regards
Last edited by XOR LX; 10-07-2013 at 05:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks