Forum Discussion
Combine Multiple Rows with Blank Values
I am not 100% sure this is what you are looking for...
If you are starting with data like...You can use the Pivot Column (Table.Pivot) feature to end up with...
Select the "Attribute" column and click the 'Pivot Column' icon on the transform ribbon.
Use the value column in the 'Values Column' and select 'Don't Aggregate' in the Advanced options.Hope this gets you pointed in the right direction.
Using the example data from above, selecting the 'Item' column and grouping with 'All Rows' aggregation will get you...
There are no columns added to the nested tables. They are just the rows that share the Item number...
Item 200 as example...You can transform the nested columns if need to though you would need to use the Table.TransformColumns function as there is no UI feature for that.
Super UserI am not 100% sure this is what you are looking for...
If you are starting with data like...
You can use the Pivot Column (Table.Pivot) feature to end up with...
Select the "Attribute" column and click the 'Pivot Column' icon on the transform ribbon.
Use the value column in the 'Values Column' and select 'Don't Aggregate' in the Advanced options.
Hope this gets you pointed in the right direction.
Thank you! That is what I did to create the columns previously.Very useful feature. Now I'm just looking to consolidate the rows. Thanks for the tip!
- jgeddes
The Group By feature would help with consolidation. Make sure that you explore the advanced options there as well. The ability to group and keep all related rows in a nested table is a very powerful tool.
is there a way i can use the group by function without creating new columns?
