UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Possible To Pivot Data From An Array Of Values, Office 2010    
 
   
larai
post May 19 2017, 06:14 PM
Post#1



Posts: 964
Joined: 8-February 02
From: California, USA


Hi,

I have a spreadsheet that contains a column titled "affected locations". This can contain an array of values or a single value. Is it possible to pivot and chart the count of the individual locations, whether the column contains an array or a single value?

DEVID Affected Locations
D-101 Alberta
D-102 Ontario, Charlotte
D-103 Alberta, Charlotte, GDL
D-104 GDL
D-105 Charlotte, MXI


In My pivot
Affected location Count of Affected Location
Alberta 2
Charlotte 3
GDL 2
MXI 1
Ontario 1


Thanks,
Lillianne
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd May 2017 - 08:10 PM