Hi Team,
In the available data I need to pick first child number based on first Pam
Available Data
| old parent | k_type | old child | old quantity | old type | child | quantity | type | child2 | quantity2 | type2 | child3 | quantity3 | type3 |
| SD0087 | Mangos | AB1197 | 0.1 | Mangos | AB0077 | 0.33 | Mangos | AS0055 | 1 | Pam | | | |
| SD0997 | Mangos | GF0097 | 0.24 | Mangos | TG6700 | 1 | Pam | WE9900 | 0.3 | Mangos | RE9988 | 0.66 | Pam |
| AG1799 | Mangos | JK8900 | 0.99 | Mangos | TG6700 | 5 | Pam | WE9900 | 0.55 | Mangos | RE9988 | 2 | Pam |
| SD3244 | Mangos | TG6700 | 0.44 | Pam | | | | | | | | | |
| FG9090 | Mangos | LG0011 | 0.88 | Pam | JK0099 | 1 | Mangos | QW9988 | 2 | Pam | | | |
| LL0099 | Mangos | TY0022 | 1 | Pam | XC0099 | 1 | Pam | | | | | | |
| DD0066 | Mangos | GF0097 | | Mangos | DF0123 | | Pam | | | | | | |
Expected Output:
I'm looking for dynamic output Where I can input multiple rows and get expected output
| old parent | k_type | old child | old quantity | old type | child | quantity | type | child2 | quantity2 | type2 | child3 | quantity3 | type3 | First Pam Child |
| SD0087 | Mangos | AB1197 | 0.1 | Mangos | AB0077 | 0.33 | Mangos | AS0055 | 1 | Pam | | | | AS0055 |
| SD0997 | Mangos | GF0097 | 0.24 | Mangos | TG6700 | 1 | Pam | WE9900 | 0.3 | Mangos | RE9988 | 0.66 | Pam | TG6700 |
| AG1799 | Mangos | JK8900 | 0.99 | Mangos | TG6700 | 5 | Pam | WE9900 | 0.55 | Mangos | RE9988 | 2 | Pam | TG6700 |
| SD3244 | Mangos | TG6700 | 0.44 | Pam | | | | | | | | | | TG6700 |
| FG9090 | Mangos | LG0011 | 0.88 | Pam | JK0099 | 1 | Mangos | QW9988 | 2 | Pam | | | | LG0011 |
| LL0099 | Mangos | TY0022 | 1 | Pam | XC0099 | 1 | Pam | | | | | | | TY0022 |
| DD0066 | Mangos | GF0097 | | Mangos | DF0123 | | Pam | | | | | | | DF0123 |
