Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concat rows -
Hi
I need a program to be able to concate all the rows in B until the cell in column A is not blank. would also want a separator between them. ie row C1 = 000034001570;000034001571;000034001582;00003400158 9 C6 = 000034032303 A B 1 000034001570 000034001570 2 000034001571 3 000034001582 4 000034001589 5 000034001589 6 000034032303 000034032303 7 000034066598 000034066598 8 000034017214 000034017214 9 000034017215 10 000034019302 11 000034019303 The issue is that I have a sheet of over 40,000 rows, also I have noticed that I have duplicates in the column B, which will have to be excluded. Its been a while since I've done any programming so any help appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concat rows | Excel Worksheet Functions | |||
howto: concat (x1:x3) | New Users to Excel | |||
Concat Macro help... | Excel Discussion (Misc queries) | |||
Concat values in two or more rows based on id and eliminate duplicates | Excel Programming | |||
Concat + dates | Excel Programming |