I am getting data in below format as, Id Data1 Data2 Data3 10 101 10 201 10 202 10 301 10 302 But I want to get data in below format without using any intermediate Table, Id Data1 Data2 Data3 10 101 201 301