decompose data

Hello! I need to decompose the following data (35.0 ; 11.0 ; 129.0 ) that I have in a cell to different cells where 35 , 11, and 129 are the code and 0 is any value of each code and it will be in another cell and the ";" is the separator ; thank you.

AttachmentSize
decompose_data.zip10.88 KB

Don't really understand what you want but

with a bit more of an understanding, I am sure I could write you a macro to do this for you. contact me if interested