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.
Problem solved. I used a formula "=A1&B1&C1".
1 Reply
- choicmRegular Visitor
Problem solved. I used a formula "=A1&B1&C1".