Generate new rows with new tasks by name data set

[AntlRo]

Hello 

Is there a tool or a way for the below :

I have a data set as such below currently for a hr company payroll :

Name |   Task Name |  hours|

John |   run | 2 |

John | walk |3 |

Susie | run | 4 |

Susie | walk | 3 |

Susie | Climb |1 |

Susie| Crawl | 1 |

Barry | Run | 5 |

I want the output to create new rows for each name and task and show zero since they had that option but didnt select it in the form ( they truly did 0 hours)

Name |   Task Name |  hours|

John |   run | 2 |

John | walk | 3 |

Jonh | Climb | 0 | -- new row

John | Crawl | 0 | -- new row

Susie | run | 4 |

Susie | walk | 3 |

Susie | Climb |1 |

Susie| Crawl | 1 |

Barry | Run | 5 |

Barry | walk | 0 | -- new row

Barry | Climb | 0 |-- new row

Barry| Crawl | 0 | -- new row

[gautiergodard · Accepted solution]

Hey @AntlRo 

Attaching one way you could do this!

Hope this helps!

[DataNath]

@AntlRo this is what I came up with. Wasn't going to post it as it's just about identical to @gautiergodard's perfectly viable solution. However, I figured that the lookup table I use is a different approach as this creates a hard list of activities to check against. Whereas, the summarize approach may fall down if you're wanting to check for hours of activities that nobody has logged at all:

This would just rely on you keeping the lookup up to date:

[binuacs]

@AntlRo One way of doing this with the batch macro

[AntlRo]

This is awesome as well thanks!