QQ48 Filterxml and Textjoin to Append Table
QQ48 Filterxml and Textjoin to Consolidate Table
การใช้ Filterxml และ Textjoin รวมข้อมูล
https://1drv.ms/x/s!Ak8Fla2fCeo6gf0tO...
0:01 Intro Append table
0:18 Best method 1 No Append
0:40 2 Manual copy paste
0:52 3 VBA
1:11 4 Power Query
1:34 5 Formula Old method Indirect Aggregate
2:36 MS 365 method
3:25 FILTERXML
5:05 Start MS365 formula
9:16 Textjoin 3D
10:35 FLTERXML to split data
11:00 Ending
/ excelwizard
/ xcwizard
/ excelsuperfan