Combine two tables

[santoshbhagade]

Hi Folks,

Could you please let me know how to attach these two tables. Please refer the attached file. Table 1 and Table 1 there is common column name is Role i have highlighted the same.
Thanks.

 

[vletm]

santoshbhagade
Is there any more rules, which would give some hints?
... or would it be - do it as You want?

 

[santoshbhagade]

santoshbhagade
Is there any more rules, which would give some hints?
... or would it be - do it as You want?

HI Vletm, Thanks for reply. I dont think so any more rules

 

[vletm]

... then You would get more rows and some cells would be empty.
...
and those 'tables' ... were sheets or how?

 

[santoshbhagade]

... then You would get more rows and some cells would be empty.
...
and those 'tables' ... were sheets or how?

is there any way we can get rid of this empty rows.

 

[vletm]

Without clear rules, You can only guess ...
eg copy above cells to empty cells
... but who knows? ... someone would care!
Already those copied cells can or cannot be in correct places!

 

[AlanSidman]

Using Power Query, file attached, I loaded both tables into PQ. Joined the two tables (Left Outer Join) based upon the common field.

let
    Source = Table.NestedJoin(#"Table 1", {"Column1"}, #"Table 2", {"Column3"}, "Table 2", JoinKind.LeftOuter),
    #"Expanded Table 2" = Table.ExpandTableColumn(Source, "Table 2", {"Column1", "Column2"}, {"Column1.1", "Column2.1"})
in
    #"Expanded Table 2"

 

[Peter Bartholomew]

@AlanSidman
I did the same and got identical results (with 50 records) from a full outer join.

 

[AlanSidman]

@Peter Bartholomew
Guess it will only make a difference if the number of records in each table is different. In this case there were 16 records in both tables so both joins return the same information.

 

[santoshbhagade]

Thanks
AlanSidman