Forum

Adam Smith
@patri0t82
Trusted Member
Joined: Dec 18, 2018
Topics: 11 / Replies: 32
Topic
Forum
Replies: 5
Views: 518
Reply
RE: Sum Multiple Columns by Matching Rows in First Column

Thank you both Mynda and Philip - you're rockstars. Philip your data matched what I was able to come up with and I couldn't be happier. Also, Mynda, y...

5 years ago
Forum
Reply
RE: Sum Multiple Columns by Matching Rows in First Column

I'm pretty sure I was able to solve the problem by taking the source data, and pivoting it so all the dates were in one column and all the regions in ...

5 years ago
Forum
Reply
RE: Sum Multiple Columns by Matching Rows in First Column

With regards to the column count issue, it seems a limit of 140 was hard-coded into the Source step. I've learned that removing that section fixes the...

5 years ago
Forum
Reply
RE: Sum Multiple Columns by Matching Rows in First Column

Thank you both for responding. I'm really hoping I can keep the file light and handle most (if not all) of the work in Power Query, but I'll trust you...

5 years ago
Forum
Topic
Reply
RE: Expanding a column with Multiple Instances across new columns

Thank you both for your replies. Catalin I was able to get your code working in my file and it was pretty close, but it still wasn't able to to begin ...

5 years ago
Forum
Reply
RE: Expanding a column with Multiple Instances across new columns

Hi, just wondering if anyone's had a chance to look into this. I hate to be a bother and waste time. I have a feeling I'm doing the only thing possibl...

5 years ago
Forum
Reply
RE: Expanding a column with Multiple Instances across new columns

My first attachment was not even created properly. Please look at this one as well to get an idea of what I'm really attempting to achieve. Thanks aga...

5 years ago
Forum
Reply
RE: Expanding a column with Multiple Instances across new columns

I did find a solution from that sort of worked, but not quite. let Source = Excel.CurrentWorkbook(){[Name="Table3"]}[Content], Grp = Table.Group...

5 years ago
Forum
Page 3 / 3