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!