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.
is there a way i can use the group by function without creating new columns?
Super UserUsing 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.