Substituir células vazias com valores de outra tabela

[scoparr]

Possuo um problema no qual necessito preencher os valores vazios da coluna fruta na tabela A com os valores de fruta na tabela B usando como referência o ID. Nesse caso , necessito de uma solução na espécie de procv, sem criar outra tabela ou coluna. Exemplo:

Tabela A:

ID	Fruta
1	Melancia
2
3	Banana
4
5	Melão

Tabela B

ID	Fruta
2	Melão
4	Laranja

O que quero: Tabela A

1	Melancia
2	Melão
3	Banana
4	Laranja
5	Melão

[mahoneypat · Accepted solution]

You could do it with a merge in the query editor, but given your sample data it would be simpler/faster to use append.  Append one table to the other in the query editor (pick Append Queries on the Home tab), and then Filter the Fruta column to remove blank rows.

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[v-eachen-msft · Accepted solution]

Hi @scoparr ,

You could use "Replace" function, it don't need to create extra columns.

= Table.ReplaceValue(#"Changed Type"," ",each (let a = [ID] in Table.SelectRows(#"Table B", each [ID] = a)){0}[Fruta],Replacer.ReplaceText,{"Fruta"})

Here is my test file for your reference.

[mahoneypat · Accepted solution]

You could do it with a merge in the query editor, but given your sample data it would be simpler/faster to use append.  Append one table to the other in the query editor (pick Append Queries on the Home tab), and then Filter the Fruta column to remove blank rows.

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat