Split Row Into Multiple Rows based on Count of Data

Hey all,

Still new to VBA so forgive me if this is easy...

Basically i have a chart that is connected to a pivot table that is connected to a table. The chart graphs projects that can be part of multiple offices and families. I would like to edit the data on the table. The way the data is set up if project A is in cell A1 and then all the offices that are involved would be in cell B1 separated by commas (1, 2, 3). I would like to be able to set up a slicer for Office and Familes so that when i filter to office 1 i would get projects that have their office set as 1 or 1,2,3 or 1,5 etc. The only way i can think of doing this is to create duplicate rows where only the office and family changes. See attachment for what i mean.

So...if all the above makes sense......could anyone assist me in writing a macro to do the above?

Thanks y'all!