![how to merge cells in a table in excel how to merge cells in a table in excel](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells/doc-merge-columns-into-one-cell-1.png)
, Customer Name, and the city under the row box. Click on the Customer_Info table, as shown in the below screenshot. Now we can drag & drop the field accordingly to see the result.
![how to merge cells in a table in excel how to merge cells in a table in excel](https://www.exceltip.com/wp-content/uploads/2014/08/1-5.png)
It will display the relationship, as shown in the below screenshot. Primary Key is the unique values that appear once in the table then, Click on OK.Select another table Products under the Related table section and select Order No.Select Customer_Info under Tables section and Order No.As there is one field, “Order No.” is common in both the tables, hence we will create a relationship between these tables by using this common field/column.It will again open a dialog box as shown below, and created tables are listed here.It will open a dialog box for creating a relationship between these tables.
![how to merge cells in a table in excel how to merge cells in a table in excel](https://i.stack.imgur.com/UNrfy.jpg)
Now click on the Relationships option under the Calculations section, as shown in the below screenshot.Click on the ALL tab in the Pivot Table Field section, and it will display all the tables created by us.read more section on the right side, as shown in the below screenshot. Click on OK then it will open a new sheet with a new Pivot Table Fields Pivot Table Fields Pivot table calculated fields are formulas with reference to other fields, and calculated values refer to other values within a specific pivot field.Tick on Checkbox “Add this data to the Data Model,” as shown in the below screenshot. A dialog box for Create Pivot Table will appear.Click on somewhere on the Customer_Info table then, Go to the Insert tab, and click on the Pivot Table option under the Tables section.Follow the same steps for another table, “ProductDetails.” We have given the name “Products” to another table.Now, click on the Table Name field under the Properties section and give the name of this table as “Customer_info.”
HOW TO MERGE CELLS IN A TABLE IN EXCEL FULL
Again, create a new column after the Last Name and name this new column as Full Name. Let’s merge the first name and last name using Flash Fill feature. This is a very good tool to use to merge cells. Flash fill feature was added to Excel in 2013 version.