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.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.Copy the selected sheets to one workbook. Merge the identically named sheets to one. Now, click on the Table Name field under the Properties section and give the name of this table as “Customer_info.” On the Excel ribbon, go to the Ablebits tab, Merge group, click Copy Sheets, and choose one of the following options: Copy sheets in each workbook to one sheet and put the resulting sheets to one workbook. It will convert our data into a table format.Our table “CustomerInfo” has column headers hence the checkbox “My table has headers” should be checked.
Then Create a table dialog box will appear.Go to the INSERT tab and click on the Table option under the Tables section. Click on any cell in the Customer Info table.Below are the steps for merging these two tables: