Combining rows [Closed]

Report
-
Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
-
Hello,

My situation is similar to a question that was asked but not exactly the same. This is how my spreadsheet looks now:

A 1 1 0 0 1 1
A 0 1 1 0 1 1
B 1 0 0 0 0 1
B 0 0 0 0 1 1

I would like to combine those into two rows like this:

A 1 1 1 0 1 1
B 1 0 0 0 1 1

If you know a way could you please explain the steps. Not just "use this formula". I'm newer to Excel so need a little more step-by-step. Thank you!

1 reply

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
456
Hi Matt,

Well, you could use a combination of IF and OR functions to check if the result needs to be a 1 or 0. Like:
=IF(OR(B1=1,B2=1),1,0)
So if either B1 or B2 is 1 then result will be 1, otherwise 0.

But depending on your amount of data it will be more beneficial to use a code.

So how much data are we talking about?
And also, is your data always grouped on 2 lines?

Do feel free to ask anything you like. I'm always happy to assist anyone wanting to learn more about Excel.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!