[3.14] gh-142965: Fix Concatenate documentation to reflect valid use cases (GH-143316)

[3.14] gh-142965: Fix Concatenate documentation to reflect valid use cases (GH-143316) #113598