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.
1 Open Calc or Excel. 2  Highlight the merged cell you want to split. 3  A merged cell will expand into multiple columns or rows. 4  Click the Merge cells button in the formatting bar. 5  Below is an example of what this button looks like in each of the versions of Excel and Calc that support this option.erge two cells using a formula. In Excel, you can merge two cells using a formula. Using the ampersand (&) in a formula acts to combine two cells or a cell and other text together. In this example, the formula =A1&B1 combines the values in cells A1 and B1 into cell C1.