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.
  • choicm's avatar
    1 year ago

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