Hi ! is there any option to combine two picklist column values. In column1 formula, if i write as column1 + column2, its not working. Is there any option to use UNION operator. Then how could two column values(picklist) can be combined, without using combined analysis ? Because i could achieve this, if i use combined analysis. Is there any option to combine columns without using combined analysis. Kindly suggest some ideas for this.
Could you please clarify if you are trying to concatenate these two picklist values on each row, or if you're trying to show these values on different rows? I suspect you're simply trying to concatenate them on the same row, in which case you can use the concatenation operator (||) between the fields (rather than +). For example, concatenating two picklist fields from the Account object: