We have an Excel table of non-standard format. Each range of 2 rows * 6 columns corresponds to 1 row * 3 columns of the standard format. The standard format table will consist of the 1^st column of the 1^st row or the 1^st column of the 2^nd row (the two have same values and just get one of them), the 2^nd column of the 2^nd row, and the 3^rd column of the 1^st row.

Below is the expected standard format table:

Use SPL XLL to do this:

=spl("=?.group((#-1)\2).(~1(1)|~2(2)|~1(3))",A1:C8)

group()function groups table rows according to the specified rule; symbol # represents the row number; slash \ performs division and gets the integer part of the result; and ~1(1) is the 1^st column of the 1^st row in the current group.

Source:https://www.reddit.com/r/excel/comments/1chvluy/how_can_i_combine_rows_in_excel/