Select Columns using existing data and Create a new table

[Anonymous]

I have the following data with me already. 

Table 1 Consists of Column A , Column B , Column C

Table 2 Consists of Column D , Column E

Now i want to create a new table as 

Table 3 Consists of Column A , Column D. 

Note: Column A is of data type Text and Column D is of Data type Decimal Number. 

Any help, suggestion on this will be of great help

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

At first, you need to add an index column( start from 0 ) in the first table.

Then add a custom column like the following codes:

=Table.AddColumn(#"Added Index", "Column4", each TableB{[Index]}[Column4])

[avatorl]

Do you have any IDs in your tables that should be used to match rows between tables? If yes, then merge the tables https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616...

Or do you have two tables with no IDs but with the same number of rows in each table and want to merge them as is (row 1 with row 1, row 10 with row 10, last row with last row)? Add Index column to both tables https://support.microsoft.com/en-us/office/insert-a-custom-column-into-a-table-power-query-2dbb579a-... and then merge two tables by index columns.