Defining Primary Data in Market Research. Primary data is information that you collect specifically for the purpose of your research project. An advantage of primary data is that it is specifically tailored to your research needs. A disadvantage is that it is expensive to obtain.
Merge adjacent cells. 1  Select two or more adjacent cells that you want to merge. 2  On the Home tab, in the Alignment group, click Merge and Center. 3  To change the text alignment in the merged cell, select the cell, and then click any of the alignment buttons in the Alignment group on the Home tab.
Here is an example: we want to combine 2 columns with the First Names and Last Names into one. Select both columns we want to merge: click on B1, press Shift + ArrrowRight to select C1, then press Ctrl + Shift + ArrowDown to select all the cells with data in two columns.