- 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
Separate Data
Hello,
I'd like to seperate my data like the attached picture shows.
Basically, there can be as many indicators as you like. It should only be separated, which contain two or more. The information from all other columns should be taken over without change. How could I solve this?
Thank you 🙂
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
1. First click on Data column and go split option.
2. Go through split Column options.
3. Click On advanced options and select Rows options only.
4. Click on Ok
regards,
naveen

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
1. First click on Data column and go split option.
2. Go through split Column options.
3. Click On advanced options and select Rows options only.
4. Click on Ok
regards,
naveen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In Transform option, choose Split Column option and choose Split into Rows option
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In Power Query.
Split the column using ',' as separator .
Select the new columns and choose 'Unpivot columns' on the Transpose menu.
Tidy up your columns aand data as required (remove unwanted columns, trim spaces etc)

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-20-2024 04:37 AM | |||
01-22-2024 10:30 AM | |||
Anonymous
| 05-03-2024 08:28 AM | ||
07-10-2024 08:03 AM | |||
Anonymous
| 08-12-2024 04:18 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |