Forum Discussion
Splitting a row into two rows by calculation
Hi i have this line in a row:
| Date | Type | Value |
| 20-04-2021 | Mixed value | 12 |
I would like to split it in to values depending on following conditions in the same sheet:
| Date | Type | Value |
| 20-04-2021 | All 1 | 100 |
| 20-04-2021 | All 2 | 50 |
As an example this would end up in following values for the split, depending on the distribution:
| Date | Type | Value |
| 20-04-2021 | Mixed 1 | 8 |
| 20-04-2021 | Mixed 2 | 4 |
Is it possible to create?
1 Reply
This sample doesn't make sense to me on how you want to split by what proportion. However, to split it to 2 rows you can just follow the video by using Query Parameter.
It is possible to split rows - YouTube
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
