Merging Datatables in excel

hi @j.murphy,

Apologies for late Response , I missed the post Notification.

So here - If we want the Data to be Pasted side by Side, We will go by the same approach only thing that will change is the Starting cell for the DataTable while pasting.

okay - we paste the first DataTable DT1 from cell A1 - Assuming the excel was blank at begging. So now Lets say if DT1 has 5 Columns - THe New DataTable has to be pasted from E1 .

to Evaluate this E1 - we will read the sheet again and get the COLUMNS Count - This will give us 5 - For 5- we will get the alphabet E and append 1 to make it E1.

Now lets say DT2 was having 2 columns - The Data will Be pasted from E1 to G Column .

Now DT3 should be pasted from G1 - Again we Read the entire Data and get the columns count - Now column count will be 7 (5+2) - We get a alphabet G for 7 , append 1 to it - we get G1. and So on…

Now How do we get alphabet wrt to the Number ?

Below are the threads to refer.


Mukesh