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.
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!
Super UserThe 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?
- jgeddes
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.
- Chewdata
Responsive Resident
Hey!
If you end up with a table that looks like the one in your example, then there might be another column in the table, that makes it unique. in that case it will create extra rows .
For demonstration purposes i've added the column Color to your data.When I pivot the column now it will create extra rows:
if I remove the column that makes it 'unique'. It wil combine them into a single row:Hopefully this helps! if so, please consider giving kudo's and accepting this answer as a solution, so other members qith the same problem can find it quicker!
