Pivot and concatenate

[Uncle Dickie]

Sorry, another pivot type problem from me! In this instance I have a table showing parts and shortages:

PartNo, Component Shortage
PART1, ResA
PART1, ResB
PART2, CapA
PART2, CapB
PART2, ResA

What I want to end up with is a single 'shortages' column against a part:

PartNo, Shortages
PART1, ResA + ResB
PART2, CapA + CapB + ResA

Is this possible and if so any pointers?
Many thanks,

Richard

[ck9663]

You can use the technique I discussed in my blog. Read more about it here

Happy Coding!


-- CK

[Uncle Dickie]

Thanks CK,
I can see how that works if I want all entries in the second column as one string, but I need it to group it by the first column. I can't see a way of changing your code to do this.

[Uncle Dickie]

I may have found a solution here

It looks to be working so far but I have more playing to do! This is the first time I have ventured into functions!