Not quite sure what you want, but you can merge columns by using a calculated field with the + sign, as Field1+Field2. You might end up with spaces where you don't have data in a particular column, but these can be removed with the Trim commands. If you could post an example of your data it would help, and I might be able to give a better solution.
I have report with Product Codes. Based on these product codes, I need to categorized them into separate dept and types. There are multiple product codes for one dept or one type. My objective is to have one product code column, one dept column and one type column.
I tried using the if function and tried embedding
the function but it return with operand types or invalid expression. ie: if(value, true, if (value, true, false) false)
However, I did manage to use the if function to separate each product codes into separate depts with each depts in one column. I have 3 columns for dept now and no idea how to merge these 3 columns into 1 and get to my objective.
Can someone please help?
Your solution worked. From the 3 separate Dept column, I was able to use the "+" function.
But I wonder if there is an easier way to get this is one step. Here's a sample of my data.
Using the calculated field, I wanted monarch to create a Dept column such as example below:-
PRODUCT CODE DEPT