create a comma-separated string from multiple rows
If you think of it, it's basically reverse engineer the process of "splitting a string into multiple rows".
I have a long list of values that are already split into different rows from the original data source, but now I want to put them back in a single string, separated by the commas.
How do I do that? my data is relatively large.
sample of original data source:
sample of ideal output:
|342062||UPS WSV, UPS GD, UPS 3D|
|194343||UPS ST, UPS SP1, UPS WXP|