I need help on how to do this... we have bom data on excel where one
cell as multiple values separated by comma(,). I need this values
transpose as rows (it's like the comma is symbol for a new row. Is
there a way to do this? here's an example of a data I originally have
on one cell "1,2,3,4,5,6,7" I need them to be on this format.

A(column)
1
2
3
4
5
6
7

Is this possible to do this on Excel? I appreciate any help....