Grouping data in different columns

I have a set of data which looks like the below:    Order Number Amount 1 Amount 2 Amount 3 Amount 4 1 138 null null null 1 null 124 null null 2 null null 127 null 2 ...