I have the below given two column.And I would like to have result as shown under the title RESULT.Could you please provide me some Macro or any formula to achieve this.

Name | Company |

CAR1 | Transport-01 |

CAR1 | Transport-01 |

ZEEP1 | Transport-01 |

ZEEP1 | Transport-01 |

CAR2 | Transport-01 |

CAR2 | Transport-01 |

B1 | Transport-01 |

B1 | Transport-01 |

B2 | Transport-01 |

B2 | Transport-01 |

CAR3 | Transport-02 |

CAR3 | Transport-02 |

ZEEP2 | Transport-02 |

ZEEP2 | Transport-02 |

CAR4 | Transport-02 |

CAR4 | Transport-02 |

CAR5 | Transport-02 |

CAR5 | Transport-02 |

<colgroup><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>

</tbody>

**RESULT :**

Company | Name | Total |

Transport-01 | CAR | 2 |

Transport-01 | ZEEP | 1 |

Transport-01 | B | 2 |

Transport-02 | CAR | 3 |

Transport-02 | ZEEP | 1 |

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>

</tbody>

Regards,

Kavvya