Data tables

[KavitaPriyaCR]

Hi You mean the result should be as:
----------------------
Orders Materials
----------------------
Order1 Material1
<BlankSpace> Material2

Order2 Material3
<BlankSpace> Material4
<BlankSpace> Material5
----------------------

If this is the case, then you should specify the cell as
'when pushing data to Datatable:

Code:

k=1
DataTable.GetSheet("SheetName").SetCurrentrow=k
DataTable("Orders","SheetName")=Order1
DataTable("Materials","SheetName")=Material1
k=k+1
'When pulling data from dataTable:
DataTable.GetSheet("SheetName").SetCurrentrow=k         ' specify required row here
getOrder=DataTable("Orders","SheetName")