It is easy to copy data from single cells to merged cells. Do this easily using VlookUp.For my VlookUp Tutorial, kindly click this link: • Vlookup Tutorial How to use VlookUp