Hi please help friends I am looking for a macro.let me explain my data first.it is a list of customer who have taken loan from multiple bank.in my data where ever a customer have multiple Bank that many rows will be there.what i want is by running a macro All customer name should be unique in single column but the multiple Bank and its address should come in single row also the headers should be mentioned automatically like bank1,bank1address,bank2',bank2address like wise.