AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

CONCAT question

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

I want to create a calculated field that will combine two dimensions.  I have episode name under VIDEO EPISODE NAME and episode number under VIDEO EPISODE NUMBER.  Instead of having each one in separate columns, I'd like to have them both in one column in order to save space in the table.  I can do this in excel with CONCATENATE but am having trouble in Data Studio.  

 

Example:  Instead of A1 = Pool of Suspects and B1 = 1, I'd like A1 = Pool of Suspects 1

 

Is this possible?  Thanks!