Set Data by Power Query in easy.

[majidsiddique]

Hi All,

i am trying to set this data by power Query but failed. kindly tell me is it easy by this power query? my desired result is on sheet2.
if it is easy to set this poqer query so please tell me.

Thanks.

[Bo_Ry]

Please try

Please Login or Register  to view this content.

I can't get "AM-CT-0135" in C25

[majidsiddique]

Hi BoRy,
thanks to reply, kindly explain me how did it? please see the snap. how i can use these steps and copy the coding for the same. i have original file more then 7500 row and unique 600 Plus Item Code. can you please tell me?
last time you mention it by formula below mention thread.

https://www.excelforum.com/excel-gen...plex-file.html

Thanks

[majidsiddique]

please see the snap

[Bo_Ry]

Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

Soure come form "Table1" if your table1 cover 7500+ row with similar structure the above M code should work.

[majidsiddique]

Thanks Bo_Ry,
you are really great, master in excel, i just copy remaining part of the file and refresh its works great.
Thanks a lot.
But can you tell me how i can do this. previous post i show you your steps. can you share any video?
Thanks

[Bo_Ry]

Please study from ExcelIsfun https://www.youtube.com/playlist?lis...mDCU2ydSnNZA_1

[majidsiddique]

Thanks Bo_Ry,
you are great.