Forum Discussion

l9854's avatar
l9854
New Member
1 year ago
Solved

Combine Multiple Rows with Blank Values

I'm creating a pivot table based on a large access database. In access, there's many rows per item number, and one column containing many attributes and another with the values of those attributes. I...
Need Help
Tips and Tricks
Tutorial Requests
  • jgeddes's avatar
    jgeddes
    1 year ago

    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.

  • jgeddes's avatar
    jgeddes
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi l9854,

Thank you for reaching out in Microsoft Community Forum.


I trust jgeddes response is accurate and will address your issue.


If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.

If the Super User's answer meets your requirements, please consider marking it as the "Accept as Solution" and click on "yes"

Please continue using Microsoft community forum.


Regards,
Pavan.