# Need a formula to consolidate a 2 column list

1. ## Need a formula to consolidate a 2 column list

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

2. ## Re: Need a formula to consolidate a 2 column list

What are you trying to accomplish? Can you not try to aggregate or whatever with a pivot table instead?

3. ## Re: Need a formula to consolidate a 2 column list

I thinking I could use a pivot table with multiple consolidation ranges? But not sure how to do it.

4. ## Re: Need a formula to consolidate a 2 column list

What are you trying to accomplish, this seems like a partial solution, what is your end game?

5. ## Re: Need a formula to consolidate a 2 column list

turn this......
Column A Column B
1AMAC33022 1132609
1AMAC33022 2724908
1AMAC33022 2724977

into this....
Column A Column B
1AMAC33022 1132609*2724908*2724977

6. ## Re: Need a formula to consolidate a 2 column list

for what purpose? that is the end state?

7. ## Re: Need a formula to consolidate a 2 column list

You will need a VBA solution to achieve this. If you are open to a VBA solution, please find the attached sheet and click on the Green Button on the sheet to get the desired output in col. C and col. D. Is this something you can work with?

Thank you.

9. ## Re: Need a formula to consolidate a 2 column list

I know that this is late but here is a way to solve your problem without using VBA.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1