Merge and Centre

H

Hardeep kanwar

Dear Expert

I have data like Below Mentioned in column A and Column B.I Want to Merge
and Center the Data in Column based on column A.

DEALER NAME
A M MOTORS MALLAPURAM 8
A M MOTORS MALLAPURAM
AALIANZ AUTOMOBILES NEW DELHI 7.35
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES Noida 15
ABHARAN MOTORS UDUPI 7.88
ABT MARUTI CHENNAI 7.89
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
AGENCY HOUSE PORT BLAIR 8.27
AGENCY HOUSE PORT BLAIR
AGR AUTOMOBILES PVT LTD VARANASI 8.77
AJMER AUTOMOBILES PVT LTD AJMER 8.44
AMAR CARS PVT LTD VADODARA 8.11
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA

For example; I want to Combine the Cell i.e b2 and b3,B4 to B7,No Need to
merge B8 Because A8 have a Same name But Differnet City. and so no.

I need a Macro.I have 6000 data in one sheet.I have 18 Sheets like this

Thanks in Advance

Hardeep kanwar
 
K

Kevin B

Assuming the data starts in row 2, you can use the following function to get
your result:

=A2&" "&B2

Then format column be for center alignment
 
H

Hardeep_kanwar

I want This See Column C

Name Average I Want This
A M Motors Mallapuram 8.00 8.00
A M Motors Mallapuram
Aalianz Automobiles New Delhi 7.36 7.36
Aalianz Automobiles New Delhi
Aalianz Automobiles New Delhi
Aalianz Automobiles New Delhi
Aalianz Automobiles New Delhi
Abharan Motors Udupi 7.89 7.89
Abt Maruti Chennai 7.90 7.90
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Abt Maruti Chennai
Agency House Port Blair 8.28 8.28
Agency House Port Blair
Agr Automobiles Pvt Ltd Varanasi 8.78 8.78
Ajmer Automobiles Pvt Ltd Ajmer 8.44 8.44
Amar Cars Pvt Ltd Vadodara 8.11 8.11
Amar Cars Pvt Ltd Vadodara
Amar Cars Pvt Ltd Vadodara
Amar Cars Pvt Ltd Vadodara
Amar Cars Pvt Ltd Vadodara
Amar Cars Pvt Ltd Vadodara
Amar Cars Pvt Ltd Vadodara
Ambal Auto Coimbatore 9.02 9.02
Ambal Auto Coimbatore
Ambal Auto Coimbatore
Ambal Auto Coimbatore
Ambal Auto Coimbatore
Anand Motor Agencies Ltd Lucknow 6.70 6.70
Anand Motor Agencies Ltd Lucknow
Anand Motor Agencies Ltd Lucknow
Anand Motor Agencies Ltd Lucknow
Anand Motor Agencies Ltd Lucknow
Anand Motor Agencies Ltd Lucknow
Apra Auto (India) Pvt Ltd. Gurgaon 8.06 8.06
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon
Apra Auto (India) Pvt Ltd. Gurgaon

Hardeep kanwar
 
D

Dave Peterson

Check your other post.

Hardeep said:
Dear Expert

I have data like Below Mentioned in column A and Column B.I Want to Merge
and Center the Data in Column based on column A.

DEALER NAME
A M MOTORS MALLAPURAM 8
A M MOTORS MALLAPURAM
AALIANZ AUTOMOBILES NEW DELHI 7.35
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES NEW DELHI
AALIANZ AUTOMOBILES Noida 15
ABHARAN MOTORS UDUPI 7.88
ABT MARUTI CHENNAI 7.89
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
ABT MARUTI CHENNAI
AGENCY HOUSE PORT BLAIR 8.27
AGENCY HOUSE PORT BLAIR
AGR AUTOMOBILES PVT LTD VARANASI 8.77
AJMER AUTOMOBILES PVT LTD AJMER 8.44
AMAR CARS PVT LTD VADODARA 8.11
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA
AMAR CARS PVT LTD VADODARA

For example; I want to Combine the Cell i.e b2 and b3,B4 to B7,No Need to
merge B8 Because A8 have a Same name But Differnet City. and so no.

I need a Macro.I have 6000 data in one sheet.I have 18 Sheets like this

Thanks in Advance

Hardeep kanwar
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macros for Merge and Centre 1

Top