Overview of data connections. A data connection is a dynamic link between a form and a data source that stores or provides data for that form. A form can have one primary data connection, called the main data connection, and it can optionally have one or more secondary data connections. The main data connection defines the main data source of the form. An XML Schema describes how data is stored in the form's main data source.
1 In your worksheet, select the text cells you want to combine and click the Merge Cells icon. 2  In the Merge Cells dialog box, set the parameters as follows:  3  Merge selected cells  field: row by row. 4  Separate values with  field: select Other option, then enter a comma and press Alt+Enter in the edit box.ou want to have the clients' addresses in one cell separated with a comma and a line break. 1  In your worksheet, select the text cells you want to combine and click the Merge Cells icon. 2  In the Merge Cells dialog box, set the parameters as follows:  3  Merge selected cells  field: row by row.
Excel automatically merge cells. up vote 1 down vote favorite. I have an Excel table with several items 1, 2, 3..., each of which has subitems 1.1, 1.2, etc. I'm using the list of subitems as my key column and populating the main items using vlookups, but only showing each main item once. Column C is raw data, A and B are formulas. Column B has notes, so the text may be long. I want to wrap the notes to take up all the rows available. I can do this manually by selecting B1:B3 and merging them, but then it won't update if I add items to column C. I don't care if the cells are merged or just wrapped and overlapping.