SOLVED
How to clean this data
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
NY2BOS
7 - Meteor
‎01-15-2025
06:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone the data coming in looks like this
Product | High User | Value_high | Low User | Value_low |
A | James | 80 | ||
A | John | 10 | ||
B | Amy | 90 | ||
B | Tom | 20 | ||
C | Nicole | 40 | ||
C | George | 10 |
However it should all be in one row and delete the blank row to look like this
Product | High User | Value High | Low User | Value Low |
A | James | 80 | John | 10 |
B | Amy | 90 | Tom | 20 |
C | Nicole | 40 | George | 10 |
Thank you
Solved! Go to Solution.
Labels:
- Labels:
- Best Practices
- Data Investigation
- Datasets
2 REPLIES 2
Bobbyt23
12 - Quasar
‎01-15-2025
06:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
aatalai
14 - Magnetar
‎01-15-2025
06:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
