Power Query won't concatenate some fields

[Pastornater]

Hi,

I have several tables imported from a Ms access db. I have edited some of the tables in power query. When I append all these separate tables into 1 and load it to a table the tables that I added custom columns to won't concatenate thier data with the rest. It should all be on one row, instead the data makes a new row for each cell.

 

[Shortmeister1]

Sounds like you have a JOIN issue. There should be a unique record identifier in both tables.

 

[Pastornater]

Sounds like you have a JOIN issue. There should be a unique record identifier in both tables.

Where do I look for that?

 

[Shortmeister1]

In your tables that you want to concatenate.