Manipulate Excel sheet

Hi Team,

I have one Excel sheet,which contains comma separated columns,I want to insert the comma separated value to next line.

Here in this attachment Fr number column and serial number count will be different and comma separated

Hi ,
Could you please clarify whether you are getting this excel value from any site? Is the excel contains only one row with values?


After PDF automation values are coming in excel format but not in proper way and excel can contain multiple rows with FR number and Serial Number Comma separated with single Quantity

Setting your IndexRow lets you move the parsed data up or down. If you put the index value into the (Excel rownumber - 1) you can automatically overwrite your initial data with the vertical orieented entries.
Just make sure to check “Add headers” in the Read-Range-Activity.