Hello, I have some trouble on presenting my data like the table below:
Data as is now:
Type | Stage | Data1 | Data2 |
Apple | NON-METASTASIS ORANGE | 0.01 | 0.2 |
Apple | METASTASIS ORANGE | 0.3 | 0.5 |
Apple | LOCAL ADVANCE | 0.4 | 0.3 |
Apple | ALL CATEGORIES | 2 | 4 |
My goal is to double some rows and change some of the text in the ‘stage’ column in the ‘new stage column’, while the ‘Data1’ and ‘Data2’ rows are also doubled. Please see an example below:
Type | Stage | New stage column | Data1 | Data2 |
Apple | NON-METASTASIS ORANGE | STAGE I ORANGE | 0.01 | 0.2 |
Apple | NON-METASTASIS ORANGE | STAGE II ORANGE | 0.01 | 0.2 |
Apple | METASTASIS ORANGE | STAGE III ORANGE | 0.3 | 0.5 |
Apple | METASTASIS ORANGE | STAGE IV ORANGE | 0.3 | 0.5 |
Apple | LOCAL ADVANCE | STAGE III | 0.4 | 0.3 |
Apple | ALL CATEGORIES | ALL STAGES | 2 | 4 |
Thank you in advance!
Solved! Go to Solution.
Hi, @arieta
Please try the below.
Please mark as an acceptable solution and like, if this works for you.
Solution
Workflow
The workflow is attached.
Cheers!