Rearrange 2 Dimensional Data to 3 Dimensional

[Anonymous]

As the topic mentioned. Example data from 2 dimensional excel data

SalesInvNo | InvDate  | ItemNo  | ItemName | UnitPrice | VAT | InvAmount | CustomerName | CustAdd

0001  |  12-7-17  |  A01  | WoodenTable  |  200  |  20  |  440  |  ABC,Ltd  |  XYZ

0001  |  12-7-17  |  A02  | WoodenChair  |  100  |  10  |  440  |  ABC,Ltd  |  XYZ

0001  |  12-7-17  |  A01  | GarbageBin  |  100  |  10  |  440  |  ABC,Ltd  |  XYZ

I want to Convert it to 3 dimensional excel data

0001 |  ABC,Ltd  |  XYZ

A01  | WoodenTable  |  200  |  20  

A02  | WoodenChair  |  100  |  10  

A01  | GarbageBin  |  100  |  10  

12-7-17 | 440

[Anonymous]

Can you explain how you got from the first table to the second table? I can see the patterns, but I can also see other ways in which the data could be grouped which make as much sense as what we see in your second table. I am sure Talend can do this, but we will need some rules to work with.