0 - 1 of 1 tags for rows to columns conversion

Hi All,

I'm new to TD and need help converting rows into a single column; 

 

Sample input data.

 

ID   key2 Indicator  

123 ABC    A1

123 ABC    B1

123 ABC    C1

345 CDE    A1

345 CDE    B1

345 CDE    C1

567 XYZ     B1

567 XYZ     C1