Forum Discussion
choicm
1 year agoRegular Visitor
Display the only value from multiple columns in one column
Hi. I have a dataset like this: How can I display the subcategory in one column? i.e. A1, B2, C2, A2, B3, C1 shown in one column. Thank you.
- 1 year ago
Problem solved. I used a formula "=A1&B1&C1".
choicm
1 year agoRegular Visitor
Problem solved. I used a formula "=A1&B1&C1".