Skip to Main Content
Status Future consideration
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.

  • Attach files