concantenate cells in multiple row
I have about 120,000 of rows with entries in A column . I want to combine all entries in Column A into one cell seperating them by semicolon but l get timed out or excel doesnt capture all in one cell. I need help in getting this done even if Vba. Any and all help will be appreciated.
Column A
1. 0088900
2. 0089334
3. 0008994
4. Engen and Sons
Until
120000. 0995789
Output = 0088900;0089334;0008994;Engen and Sons;.............until;0995789
All help appeciated
|