Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Select Columns using existing data and Create a new table

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 Consis...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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's avatar
avatorl
Impactful Individual
6 years ago

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-7ca2616d17f9

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-915b-4ebd-b622-8e7f3d1d61a6?ui=en-us&rs=en-us&ad=us and then merge two tables by index columns.