id model color quantity price
1 a black 3 300
2 b red
3 c blue 2 400
I'd like to copy the entire row where the 'quantity' column is not empty. And I'd like to put it in a specific column.
id quantity price
1 3 300
3 2 400
1 a black 3 300
2 b red
3 c blue 2 400
I'd like to copy the entire row where the 'quantity' column is not empty. And I'd like to put it in a specific column.
id quantity price
1 3 300
3 2 400