Sleeper: Build a PPT Table from Excel data that contains merged cells

Hello all,

I am a beginner with VBA and am having a hard time building a table in PPT with excel data that includes merged cells. Currently, my code loops through my excel range and brings over rows of data (unmerged). I would like for my macro to loop through column B, identify rows that are merged, then for each set of merged rows, copy over the associate rows to a ppt table.

OR

Since my macro is already bringing over the rows, is there a way to go through each table in the slides and merge cells with the same value?

Thanks in advance