Consolidated vs non-consolidated - Microsoft Community

in excel, have done regular pivot tables , ones consolidated data.  have not been able figure out if excel can cross tab pivot table pivot consists of consolidated , non-consolidated data.  let me give example.

the data collected solicited follows:

what primary business industry? (check one)  < non-consolidated - single field

what products or service influence purchase of? (check apply) <  consolidated - each response retained in own field

would pivot this.

purhasing influence	primary business
	10-builder	20-architectural	30-remodeler	40-kitchen & bath	50-manufacturer	90-other	no answer	total
01-appliances	47,533	8,471	19,466	778	319	66		76,633
02-cabinets	51,100	9,326	22,408	1,026	392	94		84,346
03-carpet	3,286	581	12,313	500	95	55		16,830
04-caulks	44,834	8,398	7,762	104	264	95		61,457

is doable.

also, can in sql

select business,
    sum(case when tbl1.[01-appliances]<>  "" 1 else 0 end) 01-appliances,
    sum(case when tbl1.[02-cabinets] <>"" 1 else 0 end) 02-cabinets,
    sum(case when tbl1.[03-carpets] <>"" 1 else 0 end) 03-carpets,
    sum(case when tbl1.[04-caulks] <>"" 1 else 0 end) 04-caulks
count(tbl1.[sub]) count
[table1] tbl1
group (tbl1.[business])

moved from: office / excel / windows 10 / office 2013

Office / Excel / Microsoft Office Programming / Office 2013