September 14, 2021
Good afternoon.
I have a file that I would like to Concatenate two ROWS and then sumif based on two conditions using Power Query.
The attached file provides the specific details.
Thank you for the insight.
Moderators
January 31, 2022
Moderators
January 31, 2022
The trick here is to first define a named range of the data you want to use. Connect to that range with PQ and Transpose the table. Now merge the first two columns and Transpose the table back and Promote the Headers and do some cleaning up. Please see if you can follow what I did in the attached file.
Note that I inserted a column title in the data for "FPR Line Name".
Insecure though what you mean by the SUMIF part of your question.
September 14, 2021
This is very helpful and resolves my first question. Excellent and thank you!
The 2nd part of the question for the sumif is this:
I want to sum all values in a row that have "Actual+Adjustment" within the column header. Example within the myData attachment: Sum Columns D+F+H, etc.
Then a seperate sum total for all values that have "Plan" in the column header. Example within the myData attachment: Sum Columns E+G+I, etc.
1 Guest(s)