I have a problem that I cannot solve by my self. I hope someone here can help me.

I am trying to convert data from rows with different lengths into to two columns.

The value of the first column remains equal to first cell of the row and is copied down to equal amount of rows as there are cells in the source row.

The second column is the rest of the cells of the source row copiend and transposed to the second column.

Below is an example of what I wish to do. Row length is max 18 cells and amount of rows may vary but is calculated in hundreds.

I found a code here that is close to what I need, but not quite there. Link:

After:

CodePudding user response：

I don't have an actual answer to this, so my apologies if I shouldn't comment, but can I ask why you're trying to do this? I can't quite wrap my head around the logic of your task.