Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Centre
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Centre
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 -- Kevin Backmann "Hardeep kanwar" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Centre
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 "Kevin B" wrote: 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 -- Kevin Backmann "Hardeep kanwar" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Centre
Check your other post.
Hardeep kanwar wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the difference between merge and centre and merge across | Excel Discussion (Misc queries) | |||
merge & centre - tricky Q | New Users to Excel | |||
Find repeat and than merge and centre | New Users to Excel | |||
undue merge and centre | New Users to Excel | |||
What is the Keyboard Shortcut of Merge and Centre Tool Command | Excel Discussion (Misc queries) |