Find non empty data through specific fields and add a column to these data, merging all data

[Lori (Li)]

Requirement:
1.Find non empty data through specific fields and format (add new column use it’s name and
value)
2.Remove empty data
3.Merge data
New_20230803_WantResult.xlsx (14.1 KB)
New_20230803.xlsx (15.5 KB)

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi
I will reply when I have solution

[Lori (Li)]

@ppr @ushu
could you help to have a look, thanks.

[Lori (Li)]

@Nguyen_Van_Luong1
Hi guys, you can refer to this post, I had simple the keywords(only English keywords ) and csv format in below post and get the soluction.

CSV data format

HI, Can you try the following sample? [image] Sample20230728-6L.zip (4.3 KB) Regards,

however, when I try to use that method to search keywords with Chinese, I cannot get the right result, so I had to create new ticket for help.