What shall I do if the the original data file is damaged in some way? How to repair the damaged file? Thank you! Couldn't retrive the original data after Append & Merge. Thank you!
@@KKLeung KK老師,感謝回復.我是用append queries as new-three or more tables,生成合併worksheet, 然後click close & load to new table，就出現左合併worksheet & 三個 worksheet copy version.
Leung Sir, it shows "list may be incomplete" above cancel icon when using merge function. It cannot show ALL items. I try "load more" but the results are the same. Would you please teach me how to solve it? By the way, I use Macbooks M365 excel
@@KKLeung I use my own raw data which is over 10k items. There are 5 workbooks, A, B, C, D & E. A is a master file and B, C, D can find the common properties that relates to D's. But E has a common properties related to D only. Therefore, I made 1st merge with D & E. Then, I made 2nd merge with A. In the 2nd merge, it cannot show all items and "list may be incomplete". I guess A workbooks include too much items. The other workbooks are included less than 1000 items.
Hi Vicky, In power query editor, it will not show all the rows of table. All the data rows will be extracted per setting of power query after the step of close and load. K.K.
簡單易明，十分謝謝KK Sir。
@@3JaneDoe Hi Jane, 多謝收看👍
Very good and clear tutoring! Thank you!
多謝你嘅好評，協助轉發俾有需要嘅朋友，就係對本平台嘅義工最大嘅支持🙏😀
Thank you, excellent
@@stevenlylaw7667 Hi Stevenly
Thanks for watching.
Did you fix the problem in VBA #9? I don’t have time to evaluate your case…..
Leung Sir, nice and I have made my own data. Very detailed guide. Thanks
Thanks for watching
原來excel裡有這個方便功能, Append同Merge最終可以生成PivotTable Report, 真係正!
期待你另一個excel功能教學, 非常感謝。
多謝收看
感謝K.K 老師🥰🥰🙏🙏🙏👍👍
Hi Paul, 多謝收看👍
What shall I do if the the original data file is damaged in some way? How to repair the damaged file? Thank you! Couldn't retrive the original data after Append & Merge. Thank you!
You may refer to the video as below. I am not sure it is workable or not.
ua-cam.com/video/ixHSFa7BSBo/v-deo.htmlsi=w1PghpTjSkWuCWP9
你好,kk老師，我想將3個worksheets合併在同一個worksheet，用左power query既append queries-three or more tables，完成時為何還會出現sheet 1,2,3既copy version，請問我應該如何解決？🙏🙏
多謝收看
1 ） 你是選擇 append as new
2 ) 當你選擇選擇 three or more tables後，在那時候和那個位置出現 三個 worksheet 展示 copy version ？
@@KKLeung KK老師,感謝回復.我是用append queries as new-three or more tables,生成合併worksheet, 然後click close & load to new table，就出現左合併worksheet & 三個 worksheet copy version.
@@kayanhui7129 1）合咸worksheet 嘅結果是否正常？
2）有三個額外worksheets (copy) 產生在同一workbook 對嗎？
How can I update the file automatically? I couldn't make it updated?!?!
Hi Phyon,
Place your mouse cursor in pivot table then select [data] ［refresh all]
Thanks for watching
KK
Leung Sir, it shows "list may be incomplete" above cancel icon when using merge function. It cannot show ALL items. I try "load more" but the results are the same. Would you please teach me how to solve it? By the way, I use Macbooks M365 excel
Hi Vicky, thanks for enquiry. Could you tell me which time slot you find the problem? Thanks
@@KKLeung I use my own raw data which is over 10k items. There are 5 workbooks, A, B, C, D & E. A is a master file and B, C, D can find the common properties that relates to D's. But E has a common properties related to D only. Therefore, I made 1st merge with D & E. Then, I made 2nd merge with A. In the 2nd merge, it cannot show all items and "list may be incomplete". I guess A workbooks include too much items. The other workbooks are included less than 1000 items.
The 2nd merge is between A workbook and 1st merge
@@kanvicky-ud5vc 多謝你嘅提問，會安排時間處理，遲啲回覆你。
Hi Vicky,
In power query editor, it will not show all the rows of table. All the data rows will be extracted per setting of power query after the step of close and load.
K.K.
Hello KK sir 請問如果sheet1只有col 1,3; sheet2 只有col 2,3; 可以點append去另一張sheet with col 1,2,3? thanks
多謝你嘅提問，會安排時間處理，遲啲回覆你。
please refer the video as below. It should provide you the solution.
ua-cam.com/video/fZYAvrk5R4s/v-deo.htmlsi=zlfD2i7A35iSulta
老師, 可否提供練習檔案嗎?
抱歉，因為相關多個文檔，而且做power query 係會根據我自己電腦文檔路徑（folder and path), 較容易引起混亂，所以未有準備示範文檔下載。
建議用自己工作嘅文檔去嘗試做類似嘅分析，相信效果會更加理想。