title: Extracting "hidden" data from expanding/collapsing pivot table - Excel
body: <p>I'm not sure if this is possible but as you can see I have a pivot table with multiple dependent and expandable fields. I am trying to concatenate the data from columns A:D into one cell which works fine in row 2 but doesn't work with blank parent cells, as you can see in column F.</p>
  
  <p>Any ideas for how to achieve this? </p>
  
  <p><strong>Pivot table</strong></p>
  
  <p><img src="https://i.stack.imgur.com/bpFjn.jpg" alt="pivottable"></p>