Reply
Sun 22 Feb, 2004 10:53 pm
Hello,
My name is Clark and I am a first time user. I found this site browsing for Excel help. I am quite new to this, and hope I can give as well as receive!
I am using the latest version of Excel for Apple OS X. I believe it is has the same feature set as it's Windows counterpart.
I am using Excel to create 'Adwords' for the Google Adwords Advertising Program. I have created a list of words I wish to advertise under, but now must append town names to each of these 'adwords'. I accomplished this by creating a table that looks like this:
Adword(R1C1)Arlington(R1C2)Concord(R1C3)
home cleaner(R2C1)home cleaner Arlington(R2C2)home cleaner Concord(R2C3)
home cleaners(R3C1)home cleaners Arlington(R3C2)home cleaners Concord(R3C3)
home cleaning(R4C1)home cleaning Arlington(R4C2)home cleaning Concord(R4C3)
home cleanings(R5C1)home cleanings Arlington(R5C2)home cleanings Concord(R5C3)
house cleaner(R6C1)house cleaner Arlington(R6C2)house cleaner Concord(R6C3)
house cleaners(R7C1)house cleaners Arlington(R7C2)house cleaners Concord(R7C3)
house cleaning(R8C1)house cleaning Arlington(R8C2)house cleaning Concord(R8C3)
house cleanings(R9C1)house cleanings Arlington(R9C2)house cleanings Concord(R9C3)
The adwords are in the first column. (I put cell the cell's address in parenthesis after it for clarity, since you can't put text into neat rows using this editor) The name of the first town I wish to advertise in is in the second column. The next town is in the third column and so forth. I use =CONCATENATE($A2," ",B$1) to put the 'adword' string together with the town name.
I have created a huge matrix of all adwords with each of the towns I need to advertise in. The problem is I now need to CREATE ONE RUNNING LIST IN A SINGLE COLUMN WHICH IS A COMPILATION OF ALL OF THESE SEPARATE COLUMNS (minus their headers). I have searched and searched for a command to accomplish this, but to no avail... Data: consolidate, data: group, insert:list, NONE OF THESE FUNCTIONS SEEM TO FACILITATE THIS ACTION.
Argh... I'm really in a pickle, as this will be ridiculously time consuming to do by hand, and REDO BY HAND every time I make a change! I simply can not believe there is no function to accomplish this. Any suggestions?...
Humbly and appreciatively yours,
Clark
Let me see if I understand what you need.
You have calculated items in cels in various columns, which you want to consolidate into one column. Is that correct?
If it is, I don't believe Excel can do it, except in the sense of using a command like =B25 in a new cel in order to get the contents of cel B25 elsewhere.
Do you have MS Access? This can be done there, and easily. Just place the contents of each column into Access (upload the spreadsheets, don't reenter by hand) and then, using an Append query, append one column to the bottom of another one, and so on.
jespah wrote:Let me see if I understand what you need.
You have calculated items in cels in various columns, which you want to consolidate into one column. Is that correct?
If it is, I don't believe Excel can do it, except in the sense of using a command like =B25 in a new cel in order to get the contents of cel B25 elsewhere.
Do you have MS Access? This can be done there, and easily. Just place the contents of each column into Access (upload the spreadsheets, don't reenter by hand) and then, using an Append query, append one column to the bottom of another one, and so on.
Hi Jespah,
Thanks for your idea. You know, I had a sneaking suspicion this could be done easily in a database program. Since I'm on an Apple, and Microsoft does not make Access for my platform I will consider obtaining FileMaker for this problem (after finding out if it has the command you describe!) Thanks again,
Clark
Most database programs (SQL) should have the ability to do append queries. Good luck! :-D
Excel
Dear profhig,
Thanks for the tip. Looks like a great site!
Clark
Stumble It!
Tweet This
Bookmark on Delicious
Share on Facebook
Share on MySpace