Hi,
I have data in 3 columns, I want to merge data into 1 cell from several rows, I think I can not describe better, If you see Picture you can understand what I need data, I need formula, any expert can help on this?
Thanks in Advance.
Regards.
Hi,
I have data in 3 columns, I want to merge data into 1 cell from several rows, I think I can not describe better, If you see Picture you can understand what I need data, I need formula, any expert can help on this?
Thanks in Advance.
Regards.
Please try at
D3
=IF(B3=B4,C3&","&D4,C3)
E3
=IF(B2=B3,"",A3&","&B3&","&D3)
or if you have Excel365
F3
=IF(B2=B3,"",A3&","&B3&","&TEXTJOIN(",",,INDEX(REPT($C$3:$C$21,($B$3:$B$21=B3)*($A$3:$A$21=A3)),)))
Last edited by Bo_Ry; 07-24-2019 at 02:09 AM. Reason: wrong result, revise formula
Hi Bo_Ry,
Thanks for helping, F3 formula is good and result as per I want but I'm using Ms Excel 2007 and it is not working on here.
F3 is an alternative - either the formula for D3 or the one for E3 should work for you. Just adapt them as required.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank AliG, it is working.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks, Already Marked as RESOLVED.
Hi again,
I just need minor amendment, I want comma below data, I have shared screenshot, after picture you will understand.
Thank You.
1st row with semicolon but if also data in below column there comma will be use.
E3
=if(b2=b3,"",a3&";"&b3&";"&d3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks