Combining multiple cells into 1

[Jveto]

Hey everyone, I've asked this question a couple times, and am still looking for a better solution. I've messed a lot with concatenate, but it is a little messy.

Basically I want to turn this

C1

C2

C3

C4

C5

C6

C7

C8

C9

C10

into this

C1, C2, C3, C4, C5, C6, C7, C8, C9, C10

Is there any Macro I can use to solve this issue?

[JieJenn]

Maybe a custom function?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Jveto]

I think that is going to work, seems like a fairly simple solution.

Now I'll go one step further...

Say I have this

C1	Part 1
C2	Part 1
C3	Part 2
C4	Part 1
C5	Part 3
C6	Part 2
C7	Part 4
C8	Part 4
C9	Part 4
C10	Part 4

Can I turn it into this?

C1, C2, C4	Part 1
C3, C6	Part 2
C5	Part 3
C7, C8, C9, C10	Part 4

Sorry for asking a lot, you don't have to help if you don't have the time, I have other ways to do this. I just often think about things could be easier, but don't know a whole lot about excel.

[JieJenn]

Give this code a try

Please Login or Register  to view this content.

[Jveto]

That worked beautifully.

My final question... Any recommendations on where I can go to start learning that? Say I wanted to modify it or create my own... That worked beautifully and could save me so much time, it would be great if I could actually understand it.

[JieJenn]

I just google everything.

[JOHN H. DAVIS]

This assumes data resides in Columns A and B. Results in C and D.

Please Login or Register  to view this content.

Thanks for the reps. Glad JieJenn's solution worked for you. Super coder.