How to make string
I have a file that contains: Supplier #, Stock # and other details.
In most cases, the original component is processed into different variants.
e.g. Steel Widget (p/n # 123) is painted in three different colours, and sold as Red Widget (p/n 123R), Blue Widget (p/n 123B) and Green Widget (p/n 123G)
So in my original file looks like;
Supplier # Stock# Description
123 123R Red Widg
123 123B Blue Widg
123 123G Green Widg
What I would like my report to look like:
123 123R, 123B, 123G
Seperating each Stock# with a comma is not essential, but may come in hand.
I am pretty sure this is possible, but I'm not sure how to approach it, let alone giving a usefull description for the Subject post. I think concatenate might be the word
Thanks in advance,