I'm brand new to coding and to this forum, so please accept my apologies in advance for being a newbie and probably not understanding what i'm supposed to say!

I was asked a question which I didn't know how to approach earlier. The user was trying to collect cell values in multiple rows from Excel (split out by a delimiter) and then create one complete column of single values in rows. Example in picture1 below. Source file is how the data is received and output is what the user is trying to do with it:

![Picture1](https://i.stack.imgur.com/wzpb1.png)

I hope I have explained that correctly. I'm looking for some python code that will automate it. There could be thousands of values that need putting into rows

Thanks in advance!

Andy