Write to Excel - skipping two columns

excel

#1

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?


#2

Hi :slight_smile:

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 = “”)


#3

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.


#4

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


#5

Okay it worked!
Thank you so much!