I have 2 columns, I need to consolidate one of the columns separated by a character.
For example, I need to turn this.........
Part# Part #2
1AMAC33022 1132609
1AMAC33022 2724908
1AMAC33022 2724977
1AMAC33034 19188468
1AMAC33034 F6ZZ-19C836A
1AMAC33051 07-0442A
1AMAC33051 1911006
1AMAC33051 19188473
1AMAC33051 F0TZ-19C836-A
1AMAC33051 FOTZ-19C836-C
into this..........
Part# Part #2
1AMAC33022 1132609*2724908*2724977
1AMAC33034 19188468*F6ZZ-19C836A
1AMAC33051 07-0442A*1911006*19188473*F0TZ-19C836-A*FOTZ-19C836-C
Thanks in Adavance. A.xlsx
Bookmarks