Skip to Main Content

Share your product feedback

Status Will not implement
Categories Reports
Created by Matthew Lynn
Created on Nov 19, 2018

Improved export of pivot tables with cells containing lists

Currently, if you create a pivot table where some cells contain lists of items, then export that table to Excel, each list is contained in a single cell which makes manipulating individual items in the list hard (i just spent 30 minutes individually converting cells using Text to Columns on each with Ctrl J as delimiter, then transposing the results back to vertical lists, then pasting back into the table.  Ideally it would be possible to have each item in the lists occupy a single cell, with the row titles in multi-row merged cells.

  • ADMIN RESPONSE
    Oct 4, 2024

    Thank you for the idea. Given the low volume of support for this idea, we do not have plans to make updates in this area at this time.

  • Attach files