Hi All,
As the title describes, I'm trying to consolidate rows from column B, with matching values in column C, into a single row. I've attached the workbook. The current layout is on sheet 1, and my desired layout on sheet 2. I tried using a Vlookup, but that only solved half the problem, now I'm stumped. Any help would be great. TY!
Probably TEXTJOIN if you have it or VBA.
I have seen one or two very complex formulas on some forums but they related specifically to the problem described and they were too complex for me to work out.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Without textjoin you need helper column
Please try at Sheet1
D2
=IF(C2=C3,B2&", "&D3,B2)
Sheet2
B2
=VLOOKUP(C2,Sheet1!$C$2:$D$22,2,0)
Or Power query in Sheet3
Please Login or Register to view this content.
Wow, thanks for your time and help! I'm currently working on getting my office suite upgraded so I have access to the textjoin formula. I don't understand fully how all of the formula's are connected yet, but I'm going to spend the weekend trying to figure it out.
Thanks again! This solution is going to save me a lot of time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks