Taking duplicates of Rows in excel based on First column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
SahadhKuruniyan
8 - Asteroid
‎10-10-2023
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
I am new to excel and I need to split rows based on Team column,
Team | Control | status |
A,B | 1 | Good |
C | 2 | Okay |
A,B | 3 | Good |
B | 4 | Good |
I need to convert like below:
Team | Control | status |
A | 1 | Good |
B | 1 | Good |
C | 2 | Okay |
A | 3 | Good |
B | 3 | Good |
B | 4 | Good |
Labels:
- Labels:
- Workflow
1 REPLY 1
binuacs
21 - Polaris
‎10-10-2023
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SahadhKuruniyan One way of doing this
