Hello,
I have a problem with writing to Excel file. I would like the data to be written from column 12-16 and then to 19 like in example B but what I am getting right now is example A. Is there anyway to do it?
Hello,
I have a problem with writing to Excel file. I would like the data to be written from column 12-16 and then to 19 like in example B but what I am getting right now is example A. Is there anyway to do it?
Hi
I think inserting null values between “Stk” and “TO BE FILLED” should do the trick. You could also try insert blank spaces (i.e. a string that contains nothing = “”)
Thank you for reply!
I am not sure if I understood your tip correctly but when I add blank spaces to the lists I cannot traspose it anymore.
It’s because they are not list, you need to use square brackets :
Try like this and if it works mark @mellouze’s post as solution
Okay it worked!
Thank you so much!