Forum Discussion

choicm's avatar
choicm
Regular Visitor
1 year ago
Solved

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 Reply

  • choicm's avatar
    choicm
    Regular Visitor

    Problem solved. I used a formula "=A1&B1&C1".