Unable to copy and paste the data into a new column in Power BI

[Anonymous]

Hi All,

Problem:

I have data in an Excel sheet(Unique ID) and I want to copy and paste this data into the existing table by creating a new column in power BI

Unique_ID(Excel sheet)

I want to create a new column here(UNIQUE_ID) and paste the above data into the newly created column:

Can someone please help me here?

Thank you

Kindest Regards

Sri

[amitchandak]

@Anonymous , Paste in Edit data. Then use List.Zip

Power BI Combine Tables Vertically(Row by Row). List.Zip -Power BI Combine Tables Vertically(Row by Row). List.Zip

How to Enter Data and Edit it-https://youtu.be/5nE7YGT72kU

Here you only need to paste