I have a PO which contains several number of line items(Structure is same). So i made one layout and i am able to get the data from all the rows and i am exporting it in Excel. The problem here is, In some columns data is in 2 lines like, for suppose if we take MRP it is 1895.00. On PO it is printed as 1895 in one line and .00 in another line. So in Excel I am getting space for 1895 and .00.
So, how could i get recognize this in a single line?? Because i want to remove that space in Excel??