Good morning ,
lets say I have two usernames column and each username has a value attached to it . I want to merge these two set in one set.
Some usernames are in both columns , in that case i want to sum the values .
I think the based way to describe what I want to do is attaching a little example excel question.PNGexcel answer.PNG
Array both off with sumifs.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
sorry for my mistake, I attached an example here
1. There are trailing spaces in the names in column D.
EITHER... leave them and use:
=LET(A,TRIM(VSTACK(A3:B5,D3:E5)),B,UNIQUE(INDEX(A,,1)),C,BYROW(B,LAMBDA(x,SUM(IF(INDEX(A,,1)=x,--INDEX(A,,2))))),HSTACK(B,C))
OR get rid of them (preferable.. use clean data if at all possible) and use:
=LET(A,VSTACK(A3:B5,D3:E5),B,UNIQUE(INDEX(A,,1)),C,BYROW(B,LAMBDA(x,SUM(IF(INDEX(A,,1)=x,--INDEX(A,,2))))),HSTACK(B,C))
Whichever way you go... adjust the bits in red to suit your real data.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Re: basic question about merging two column
with Power Query
(tailored to your example)
Please Login or Register to view this content.
username Value jack jill john ann
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks