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.
Contact Information. This short guide shows you how to merge/combine two data columns in an Excel spreadsheet. 1.) Here is an example of what we want to accomplish. The plan is to combine the area codes column with the phone numbers column into a single column.I also want to insert a dash after the area code. 2.) The first step is to enter a formula that is going to combine the cells. Go to Cell C2 and type: =A2&-&B2.The - means to insert a dash between the data of our two columns. 3.) Now right click on the Fill Handle of cell C2. also want to insert a dash after the area code. 2.) The first step is to enter a formula that is going to combine the cells. Go to Cell C2 and type: =A2&-&B2. The - means to insert a dash between the data of our two columns. 3.) Now right click on the Fill Handle of cell C2.