Log In
Register
Home
April 21, 2015
Offline
Hi -
Hoping someone can help.
In the attached query sample result, the queried data has a purchase order number but the description changes slightly. These changes have no consistent delimiters nor are they blank.
How do you query the data and then fill down column B based on the first value in column A?
My goal is to group by Column A & B summarizing all the records.
Thanks in advance.
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi Carolyn
You could use a Pivot Table but first you need to create a Helper Column.
Please refer attachment.
Hope this helps.
Sunny
July 16, 2010
Offline
Hi Carolyn,
You can use Power Query Group By to get the desired results too. See attached.
Mynda
Answers Post
April 21, 2015
Offline
Thank you SunnyKow and Mynda!
Both answers were helpful, but as I plan to load the query table into Power Pivot, Mynda's response best fit my needs.
I was missing the second line under new column "All Rows" in the Group by Advanced. See attached screen shot.
I now have the results needed for the data model.
Have a great day!
Carolyn
1 Guest(s)
