Log In
Register
Home
September 14, 2021
Offline
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.
See Answer
Trusted Members
Moderators
January 31, 2022
Offline
Hi Jason,
Please try to upload the file again as it didn't follow through. Don't forget to press "Start upload" before pressing Submit Reply.
Riny
September 14, 2021
Offline
Please find attached file.
Trusted Members
Moderators
January 31, 2022
Offline
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
Offline
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)
