Splitting a row into two rows by calculation

[bilingual]

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?

[Anonymous]

@bilingual 

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.