Tabellen zusammenführen mit Datenergänzung

%3CLINGO-SUB%20id%3D%22lingo-sub-1880312%22%20slang%3D%22de-DE%22%3EMerge%20tables%20with%20data%20supplement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1880312%22%20slang%3D%22de-DE%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20want%20to%20merge%20multiple%20tables.%20The%20structure%20of%20the%20tables%20is%20the%20same%2C%20only%20the%20data%20in%20the%20cells%20are%20different.%20When%20merging%2C%20the%20data%20should%20not%20be%20overwritten%2C%20but%20should%20complement%20each%20other%20in%20the%20cells.%20Is%20that%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20happy%20for%20your%20help!%3C%2FP%3E%3CP%3ELG%2C%20Bibo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1880312%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881126%22%20slang%3D%22en-US%22%3ERe%3A%20Tabellen%20zusammenf%C3%BChren%20mit%20Datenerg%C3%A4nzung%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881126%22%20slang%3D%22en-US%22%3EServus%20Bibo%3CBR%20%2F%3E%3CBR%20%2F%3ESure%20you%20can.%20Personally%2C%20I%20would%20do%20this%20with%20the%20append%20function%20in%20Power%20Query.%20This%20video%20shows%20how%20it's%20done.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Db1jSi7xkmkA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Db1jSi7xkmkA%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi!

Ich möchte mehrere Tabellen zusammenführen. Der Aufbau der Tabellen ist gleich, nur die Daten in den Zellen unterscheiden sich. Beim Zusammenführen sollen sich die Daten nicht überschreiben, sondern in den Zellen ergänzen. Ist das möglich?

 

Über eure Hilfe freue ich mich!

LG, Bibo

2 Replies
Highlighted
Servus Bibo

Sure you can. Personally, I would do this with the append function in Power Query. This video shows how it's done. https://www.youtube.com/watch?v=b1jSi7xkmkA
Highlighted

Hello @Bibo33,

 

Perhaps you are looking to append your tables? This would create a new table that contains all rows from the first table followed by all rows from the second table.

See more here:

https://support.microsoft.com/en-us/office/append-queries-power-query-e42ca582-4f62-4a43-b37f-99e2b2...