Synchronizing values in columns

Kamal Agnihotri
Kamal Agnihotri used Ask the Experts™
on
this is an Excel Question.

Column A      Column B     Column C     Column D    Column E
1314579        1314579       Alpha            xx                yy
1314579        1314579       Beta             xx                yy
1314579        1314579       Gama           xx                yy
1314579        1314579       Delta            xx                yy
1314577        1314577       Alpha            xx                yy
1314577        1314577       Beta             xx                yy
1314566        1314566       Camp           xx                yy
1314588        1314588       Alpha           xx                yy
1314588        1314588      Beta             xx                yy
1314588        1314588      Gama           xx                yy

---##############################
Upon the push of a button, on the excel sheet, arrange the above as follows

10 rows get reduces to 4 rows like below.

Column A      Column B     Column C                               Column D    Column E
1314579        1314579       Alpha/Beta/Gama/Delta            xx                yy
1314577        1314577       Alpha/Beta                                xx                yy
1314566        1314566       Camp                                        xx                yy
1314588        1314588       Alpha/Beta/Gama                     xx                yy
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this. It assumes that the data starts in row 1. If not then change the FIRST_ROW constant that you'll find in the macro.
29093209.xlsm

Author

Commented:
Martin, Thanks. That worked.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
That's good. Please don't forget to close the question.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Martin, Just a small change. Put the result in sheet 2 and keep the sheet 1 as is. I mean, when we press the "consolidate" button in sheet 1, the result should shows up in Sheet 2 keeping the original in sheet 1.
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
OK. I also made it so that column "C" on sheet2 will be just wide enough to show all the data.
29093209a.xlsm

Author

Commented:
Very helpful. I will close the question. Thanks Martin.
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
              Experts Exchange Top Expert VBA (current)

Author

Commented:
Hi Martin, You are indeed a very learned person. I am delving to VBA for Applications in support of Excel and Access. Can you suggest a good book on VBA which has examples and code that can be downloaded instead of typing it.

Thanks.

Kamal
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I don't have any actual advice about that since I'm basically a self-taught programmer and the last language I learned from a book was BASIC back in the 70's. It was in pre-web dark-ages days so it was an actual book:) I do know however that if you search for VBA tutorial that you'll get a lot of hits. If you run into things you don't understand I'll be happy to answer a couple of questions here and/or you can ask new questions and a lot of us will be happy to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial