I have a large spreadsheet that has several numbers in a single column. I would like to create a new row for every number in the column, while maintaining the other columns data, until every column has only one number. Due to proprietary reasons, I cannot provide the workbook so I will do my best to give an example of the issue,

What I have:

1 23, 43, 53 6 8 9 (The 23,43, and 53 are in the same column; everything else is in its own column)

What I would like to create:

1 23 6 8 9
1 43 6 8 9
1 53 6 8 9

I hope this makes sense, and someone can help me.