Can you re-post what you have to date? You mention merge cells. I hope that you are not merging cells as that will mess up any attempts at Pivot Table creation.