Formatting Data the smart way

P

pralav

Hi

I have 3 columns and lets name it as A,B,C and 6 rows. I am trying to
pull all those data in the 6 rows to the first row. I still want to
keep the data in the same format as they were in seperate rows and
seperate colums but I want them in one row

a b c
abc 23 2
abc 3 54
abc 78 67

I am trying to figure out a way in which i can have

a b c
23 2
abc 3 54
78 67

I want to get the values of abc in one row . Appreciate your time.
 
Top