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

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