SOLVED
Split data and join them together
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
niteshsharma677
7 - Meteor
‎06-09-2023
10:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
I need to convert following input to following output. How can I achieve this ?
Input
F1 | F2 | F3 |
Sub | 1st attempt | 1st attempt passed |
Eng | 45 | 34 |
Math | 56 | 32 |
Sub | All attempt | All attempt passes |
Eng | 56 | 23 |
Math | 44 | 22 |
Output
Sub | 1st attempt | 1st attempt passed | All attempt | All attempt passes |
Eng | 45 | 34 | 56 | 23 |
Math | 56 | 32 | 44 | 22 |
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
ShankerV
17 - Castor
‎06-09-2023
10:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Step 1: Use Multi row function to numbering
Step 2: Use Filter tool
Step 3; Join the datasets
Many thanks
Shanker V
‎06-09-2023
11:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ShankerV
Thanks for your input.
What exactly to be done in the multi row function ?
ShankerV
17 - Castor
‎06-09-2023
11:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One way of doing this.
Step 1: Input
Step 2:
IF [F1]="SUB"
THEN [Row-1:Temp]+1
ELSE [Row-1:Temp]
ENDIF
Step 3:
Step 4:
Many thanks
Shanker V
‎06-09-2023
11:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot @ShankerV !