I do not know vba at all so I was wondering if someone could help me out with a VBA code I'm trying to create.
I have bunch of data that I have. I have data in columns A to W. 

I had one column that has multiple data separated out by commas like so:

```
Col V  |  Col W 
----   |  ----
1      |angry birds, gaming
2      |nirvana,rock,band

```

What I want to do is split the comma separated entries in the second column and insert in new rows like below:

```
Col V|Col W
---- |----
1    |angry birds
1    |gaming
2    |nirvana
2    |rock
2    |band

```

Basically, I want to replicate this 

[Excel macro -Split comma separated entries to new rows](https://stackoverflow.com/questions/41003866/excel-macro-split-comma-separated-entries-to-new-rows)

but I want to do this while keeping all of the data in columns A-V intact. Also note that column W can have up to 40 items that need to be separated.

Thank you very much!