| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If value in a colum the same concatenate another colume
Hi
This is tricky to explain so I will show the output I want below, basically if the same unique value is in one column I would like to concatenate values from those unique value in the existing column to create one row. Easier to demonstrate. I wonder would anyone know some macro code to achieve this.. Head1 Head2 123 joe 154 steve 123 tom 129 kate to give head1 head2 123 joe,tom 154 steve 129 kate Thank you for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Are there any macros to lock a colum after a colum had been freezed-pane? | Excel Discussion (Misc queries) | |||
| Change from row to colume n colume to row | Excel Programming | |||
| Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
| Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
| How can I look up max of one colume and display the colume to the. | Excel Worksheet Functions | |||
Threaded Mode
