Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display the only value from multiple columns in one column
09-25-2024
08:40 PM
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.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024
10:53 PM
Problem solved. I used a formula "=A1&B1&C1".

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 03-26-2024 01:18 PM | ||
06-03-2024 10:16 PM | |||
06-13-2024 06:49 PM | |||
10-09-2023 01:35 AM | |||
03-26-2024 03:26 AM |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
51 | |
46 | |
39 | |
27 | |
13 |