SOLVED
Group by each Employee Name the values
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
JJ747
6 - Meteoroid
‎10-12-2022
10:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have an Excel data with the following rows and columns as
Name | Value |
EMP | 100 |
TYPE 1 | 10 |
EMP | 100 |
TYPE 2 | 12 |
EMP | 100 |
TYPE 3 | 14 |
EMP | 101 |
TYPE 1 | 12 |
EMP | 101 |
TYPE 2 | 14 |
EMP | 101 |
TYPE 3 | 16 |
and I would like to have my output as
EMP | TYPE 1 | TYPE 2 | TYPE 3 |
100 | 10 | 12 | 14 |
101 | 12 | 14 | 16 |
Any help is much appreciated.
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Expression
1 REPLY 1
gautiergodard
13 - Pulsar
‎10-12-2022
10:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @JJ747
Please see attached for a proposed solution!
Please accept this post as a solution if it provided an answer to your question.
Hope this helps!