Repetitive columns to simple horizontal table

Originally Posted by :) Sixthsense :)

Or

Use pivot table, refer the attached file for details

Thanks Sixthsense, it makes a lot of sense.