MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SET @sql = NULL;

SELECT GROUP_CONCAT(
             CONCAT('SUM( dismissals =''', dismissals, ''' ) AS ',dismissals)
       )
  INTO @sql
  FROM ( SELECT DISTINCT dismissals FROM tab ) t;
       
SET @sql = CONCAT('SELECT opposition,',@sql,' FROM tab GROUP BY opposition'); 


PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Table 'fiddle.tab' doesn't exist


CREATE TABLE `tab`(`company_name` VARCHAR(15), `action` VARCHAR(15), `pagecount` INT);
	
INSERT INTO `tab` VALUES
	('Company A', 'PRINT', 3),
	('Company A', 'PRINT', 2),
	('Company A', 'PRINT', 3),
	('Company B', 'EMAIL', NULL),
	('Company B', 'PRINT', 2),
	('Company B', 'PRINT', 2),
	('Company B', 'PRINT', 1),
	('Company A', 'PRINT', 3)

Records: 8  Duplicates: 0  Warnings: 0


SET @sql = NULL;

SELECT GROUP_CONCAT(
             CONCAT('SUM( `action` = ''', action, '''',pc0,' ) AS ',action,pc1)
       )
  INTO @sql
  FROM ( SELECT DISTINCT `action`, 
                IF(`pagecount` IS NULL,'',CONCAT('page',`pagecount`)) AS pc1,
                IF(`pagecount` IS NULL,'',CONCAT(' AND `pagecount` = ', pagecount, '')) AS pc0
           FROM `tab` 
          ORDER BY CONCAT(action,pc0)) t;

SET @sql = CONCAT('SELECT company_name,',@sql,' FROM `tab` GROUP BY company_name'); 
SELECT @sql; 

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;


@sql


SELECT company_name,SUM( `action` = 'EMAIL' ) AS EMAIL,SUM( `action` = 'PRINT' AND `pagecount` = 1 ) AS PRINTpage1,SUM( `action` = 'PRINT' AND `pagecount` = 2 ) AS PRINTpage2,SUM( `action` = 'PRINT' AND `pagecount` = 3 ) AS PRINTpage3 FROM `tab` GROUP BY company_name



Statement prepared




company_name
EMAIL
PRINTpage1
PRINTpage2
PRINTpage3


Company A
0
0
1
3

Company B
1
1
2
0