Excel '07

I am trying to take data that is given in 2 cells on the same row and transpose the second cell which is comma delimited to multiple rows. I would also like to copy the adjacent cell (left in the sample below) to each new row. Preferably, this would be generated on a new sheet. I've been trying to find a Macro to do this. Any help would be greatly appreciated.

I am trying to take data that is given in 2 cells on the same row and transpose the second cell which is comma delimited to multiple rows. I would also like to copy the adjacent cell (left in the sample below) to each new row. Preferably, this would be generated on a new sheet. I've been trying to find a Macro to do this. Any help would be greatly appreciated.

RECEIVED AS | |

PROJECT1 | ITEM1,ITEM2,ITEM3,ITEM4,ITEM5 |

PROJECT2 | ITEM6,ITEM7,ITEM8,ITEM,ITEM10 |

CHANGE TO | |

PROJECT1 | ITEM1 |

PROJECT1 | ITEM2 |

PROJECT1 | ITEM3 |

PROJECT1 | ITEM4 |

PROJECT1 | ITEM5 |

PROJECT2 | ITEM6 |

PROJECT2 | ITEM7 |

PROJECT2 | ITEM8 |

PROJECT2 | ITEM9 |

PROJECT2 | ITEM10 |

## Comment