@Sweety_Girl Is there a way to have a more standardized result datatable, or does it have to be flexible?
If you can make a standardized one, it will be a lot easier. Using Rollno1 as an example, you can easily assign the row number data from the individual person to the corresponding column number in the final datable (similar to transposing data from rows to columns). Same for the Empno1 data. With a fixed results table, you will also know which column number to assign the ‘data’ figures. The only downside to this is that you will likely have several completely blank columns (say, for example, if you created a fixed results table with ‘Name’, 5 ‘Rollno’ columns, 5 ‘EmpNo’ columns + the ‘data’ column on the end).
If you do need a flexible final datatable. You will need to incorporate a few activities to look into every person’s datatable you receive and determine what the likely maximum row numbers are for ‘Rollno’ and ‘Empno’ (the maximum number of rows will be three for both, using the above example). Once the maximum row numbers are determined, this will equal the number of columns you will need add/build into the final datatable (‘Name’, 3 for each + the ‘data’ column (8 columns total)), and from which you can assign the row data to the corresponding column numbers, including blank data.
I hope the above makes sense.