LinkBack URL
About LinkBacks
I have a spreadsheet with 5 columns containing 35 rows of data each. Can I select these and easily combine them to one column (for a single column with all 175 rows of data)?
I have a spreadsheet with 5 columns containing 35 rows of data each. Can I select these and easily combine them to one column (for a single column with all 175 rows of data)?
Yes. What are the ranges and where are they to be combined ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I have several spreadsheets where I want this done, and the number of columns and rows vary, but in this particular case its columns A to E, rows 11 to 45...
I'd like to combine them to column F..
Sounds like we might be opening a can of VBA worms but in terms of your specific example...
above would paste into F2 onwards (or from first non blank in F onwards)
Please Login or Register to view this content.
Hopefully that helps in part.
Thanks, that works well!Any way I can do this based on my selection, not on ranges set in the code?
It depends... given how varied the selection can be one approach would be something like:
but this is still open to error depending on size of range areas etc... output point being mid way up a blank column etc...Please Login or Register to view this content.
Last edited by DonkeyOte; 10-28-2009 at 01:03 PM.
Perfect, thank you very much!
In Cell F1:
will stick all the data in the first row, columns A to E, into a single string (which can then be converted to another data type, if necessary).Please Login or Register to view this content.
Have you actually tried your own suggestion ?
Well, now that you question me, it hadn't occured to me that Concatenate doen't accept an array input and the values will have to be listed out comma-seperated style, so... I guess the answer to your question is "no."Originally Posted by DonkeyOte
DonkeyOte: Is it possible to put the combined columns onto the clipboard rather than to a new column?
Why the clipboard ?
I'm using the spreadsheet to create variations on different words, I then need the results copied to another application. So I'm hoping I can select what I need and then click a button to put this onto the clipboard in a single list to be copied to the other application.
regards using the Clipboard with VBA
see: http://www.cpearson.com/excel/Clipboard.aspx
Given the thread is now running in two places (and you have responses on the other) I myself won't spend time large amounts of my time looking at this I'm afraid.
Also as detailed in the infraction you are obliged to provide links to your cross post(s).
Good observation. It bothers me that I have to put commas or "&" between cell references to concatenate a range.
I can do if a range reference works with Concatenate.
Chaitanya
Excel Expert and Excel Consultant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks