Combining Columns from Different WorkSheets

[only1hawkeye]

I was wondering anyone can help, I've got 3 worksheets with data coming from different sources and I need create a new worksheet based the combined data from a single column. Basically I need to be able to take the unique name column from each workbook and generate a single unified column. I need this to be dynamic so that changes to the 3 original sheets are reflected in the new column. Something like this:
Combining_Columns.png

Google's letting me down on this one, all I can get is how to concatenate columns.

Thanks in advance. (First post, be nice )

[Pete_UK]

Welcome to the forum.

It would help if you attached a sample Excel workbook, as a picture is not much use to us. Just follow the instructions in the yellow banner at the top of the screen.

Pete

[sandy666]

you can try Power Query , Append all tables from each worksheets and as alternative, remove duplicates

[only1hawkeye]

Thanks Pete_UK, I've attached sample here. In the actual spreadsheet I'm working on the content in Sheets 2-4 is pulled in via a PowerQuery.

Combining_Columns_Example.xlsx

[only1hawkeye]

Cheers Sandy666, I need to up my Power Query game, I had a feeling a solution might lie there. I'll give it a go.

[sandy666]

Cheers Sandy666, I need to up my Power Query game, I had a feeling a solution might lie there. I'll give it a go.

sure, here is more about: https://learn.microsoft.com/en-us/power-query/

[only1hawkeye]

Thanks Sandy666, got it sorted. Appending in Power Query was the solution.

[sandy666]

My pleasure

Have a nice day