PDA

View Full Version : Merge all data in column just to 1 cell



parscon
05-10-2012, 02:29 AM
I have Column A and Column B and Column C till Column G

and I have data on them , now i want to merge all data in their cell 1 that mean :

all data on column A merge to A1

all data on column B merge to B1

all data on column C merge to C1 and also for others till G

and also i have some blank cell in columns . for example :

in column A i have data like :

A1 : DATA1
A2 : DATA2
A3 : DATA3
A4 :
A5 : DATA4

A1 : DATA1 , DATA2 , DATA3, DATA4


also maybe in Column A or other columns we do not have any data .

Thank you for your help

Bob Phillips
05-10-2012, 03:25 AM
Why? That seems perverse.

parscon
05-10-2012, 03:29 AM
Dear xld ,
I upload my sheet , please check it i want to merge all coulmn to their 1 cell .

Thank you .