I am trying to Group by parent code and count the parent groups and applying a parent id to each child record
Current record set
| Parent code | Child record ID | Child code | Qty per |
| abc | 1 | 3658 | 2 |
| abc | 2 | 8452 | 1 |
| def | 1 | 7458 | 2 |
| def | 2 | 9658 | 5 |
| def | 3 | 2358 | 1 |
| ghi | 1 | 4521 | 2 |
| ghi | 2 | 1528 | 8 |
| ghi | 3 | 3325 | 1 |
| ghi | 4 | 4256 | 1 |
| | | | |
| | | | |
I have sorted by Parent code. Now I would like to count the parent groups and apply the parent ID to each child record:
| Parent ID | Parent Code | Child record ID | Child code | Qty per |
| 1 | abc | 1 | 3658 | 2 |
| 1 | abc | 2 | 8452 | 1 |
| 2 | def | 1 | 7458 | 2 |
| 2 | def | 2 | 9658 | 5 |
| 2 | def | 3 | 2358 | 1 |
| 3 | ghi | 1 | 4521 | 2 |
| 3 | ghi | 2 | 1528 | 8 |
| 3 | ghi | 3 | 3325 | 1 |
| 3 | ghi | 4 | 4256 | 1 |
I have tried with the summary tool and the multi-row formula tool and can not get the desired result. I feel the Multi-row formula would do it; I nee a little help getting it right.
RRSmith
