4.12 Merge by column - one to many - leave subsequent rows empty

 

Before merging:

Types.xlsx

imagepng

Foods.xlsx

imagepng

After merging:

imagepng

Script:

A
1 =T(“Types.xlsx”)
2 =T(“Foods.xlsx”)
3 =A1.align(A2:Type,Type)
4 =A2.new(Type,Name,UnitPrice,A3(#).Description)
5 =T(“FoodsDescription.xlsx”,A4)

A3: Align means A1 is aligned to A2 with alignment conditions as Type field of A2 and Type field of A1; only the first row is aligned if there are duplicate data in A2