Looking for a sub to do this, thanks for any help
Data in cols A and B in Sheet1 (Data is sorted by col A)
ID_A Val_1
ID_A Val_2
ID_B Val_3
ID_B Val_4
etc
Desired Output in a new sheet, cols A and B, with multiple results per ID separated by comma
ID_A Val_1,Val_2
ID_B Val_3, Val_4
hi there. do upload an excel sample so that we do not have to manually key in your data to do a testing.
try this code here:
How to install your new code
Please Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks. The original data in columns A and B are all text numbers - long strings with several leading zeroes, eg:
000100014007
000100014008
In Desired Results, the results seem to convert col A & B into real numbers, and column B has mixed results (some correct, some incorrect), it is also affected by the comma separator
How could the above be overcome? I'm ok to use another separator (but results should all be retained as textnumbers
Am not able to upload sample file, but here's the sample data
Data
002000208886 000100011007
002000208886 000100014001
Desired Output, with colon (as separator
002000208886 000100011007:000100014001
Max
Singapore
Try this to start with.
Please Login or Register to view this content.
Last edited by bakerman2; 10-19-2017 at 03:28 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Many thanks, bakerman2. Works well, and noticed that Column A data does not need to be pre-sorted
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks