I have 2000 rows of data in excel which are some names of various medicines. I want to make those single column of data into two columns. For example, let us say a single A4 sheet can accommodate 20 rows of excel. So first i want to print first 20 product names in column A and then next 20 in column B. Again remaining needs to get printed from row number 21 to 40 in column A and then again column B like that. It is like printing in a book format. That number 20 is not fixed. Its just an example i said. i want robot to find the page break dotted line and then it has to print accordingly in both the columns.A and B alternatively…once printing in A column finds the page break, then continuation has to start from column B. Again start from column A like that. Is it possible?
images (3) (1)|459x320