I have a scenario to write the value of lists in excel in multiple rows and columns .
Hi @nutan, please check this link.
The code extracts data from the web into multiple lists, then for each list, writes the data into multiple rows in a single column.
Each list’s items are written to a single column.
Perhaps it will help.