Yvonne Love
Member
I've been trying to come up with a way using either formula, power query, or VBA, to determine work by primary location. The attached has a table with client numbers, locations, and % of work for those locations for the last 5 years (2013-2018 - all separate columns). I would like to find a way to produce the data in column P without the use of too many helper columns. With the addition of several columns, I can use an index/match/offset combo, and then combine the text from there, but that gets difficult to read and can sometimes be confusing. So I am looking for other solutions. I am very comfortable with formulas, moderately comfortable with Power Query, and a little comfortable with VBA, so I am trying to find solutions in that order. But any solution that makes combining this text easier, I will totally work with it. I feel like there's an obvious solution I'm completely overlooking, but I've been playing around with this for a couple of hours and nothing else has come to me.
Thanks in advance,
YL
Thanks in advance,
YL