Create a pivot table with col1 and col2 as dimensions and Sum(values) as an expression/measure. Then pivot the table - click the col2 header and drag the red position indicator to the top until it switches to horizontal.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
