For anyone who found this because of the same problem with Azure Data Studio, this ADS issue on GitHub provides the remedy for that tool:

https://github.com/microsoft/azuredatastudio/issues/9898#issuecomment-940401615

Essentially, the ADS setting is at Settings > Data > Query Editor > Results: Copy Remove New Line

Uncheck this setting to retain the newline when copying to the clipboard.