Powershell - How to embedded multiple sql query into powershell

Guys,
I need to know how I can run multiple  sql query in the  powershell script and output the result into csv file, for example each query will return  some set of records  and  the output of the query  should look exactly as per  xls report attached on the output structures.
Actually I did posted on the same help from the link https://www.experts-exchange.com/questions/28999380/How-to-run-in-powershell-for-multiple-sql-query.html but what was  lack there  is the output of the report does not meet my interest.

***************************************************************************************
Check SQL Server Logins Audit
***************************************************************************************
*/
SET NOCOUNT ON;
PRINT N'6.03 -  Auditing Enabled for Failed and Successful Logins';
DECLARE @AuditLevel int
EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', 
   N'Software\Microsoft\MSSQLServer\MSSQLServer', 
   N'AuditLevel', @AuditLevel OUTPUT
SELECT @@servername as ServerName, CASE WHEN @AuditLevel = 0 THEN 'None'
   WHEN @AuditLevel = 1 THEN 'Successful logins only'
   WHEN @AuditLevel = 2 THEN 'Failed logins only'
   WHEN @AuditLevel = 3 THEN 'Both failed and successful logins' 
   END AS [AuditLevel] 

   SET NOCOUNT OFF;
/*
***************************************************************************************
Check SQL Authentication Setting
***************************************************************************************
*/
SET NOCOUNT ON;
print  N'3.1 Set The Server Authentication Property To Windows Authentication mode';
SELECT @@servername as ServerName, CASE SERVERPROPERTY('IsIntegratedSecurityOnly')   
WHEN 1 THEN 'Windows Authentication'   
WHEN 0 THEN 'Windows and SQL Server Authentication'   
END as [Authentication Mode] 

SET NOCOUNT OFF;

/*
***************************************************************************************
Check The DB Trustworthy ON or OFF 
***************************************************************************************
*/
SET NOCOUNT ON;
print  N'2.9 Set the Trustworthy Database Property to Off';
SELECT name as DatabaseName, CASE  when is_trustworthy_on  =1  Then 'SET' ELSE 'Not SET' END AS DB_trustworthy_status , 
                             CASE  when is_trustworthy_on  =1  Then 'Failed' ELSE 'Passed'  END AS trustworthy_CIS_status 
from sys.databases where database_id >4
SET NOCOUNT OFF;
/*
***************************************************************************************
Check SQL Configuration Setting
***************************************************************************************
*/
SET NOCOUNT ON;

print  N'SQL Configurations Checks';
IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE name = '##Configurations' AND type in (N'U'))
DROP TABLE ##Configurations;
CREATE TABLE  ##Configurations(
[Name] varchar(100) NULL,
[Value] varchar(10)  NULL,
[Description] varchar(100) NULL
)

Insert into ##Configurations select name,convert( varchar(20),value),[description] from sys.configurations where name in 
( 'Ad Hoc Distributed Queries',
'CLR Enabled',
'Cross DB Ownership Chaining',
'Database Mail XPs',
'Ole Automation Procedures' ,
'Remote Access',
'Remote Admin Connections',
'contained database authentication',
'Scan For Startup Procs',
'xp_cmdshell',
'Default Trace Enabled',
'Login Auditing',
  'SQL Mail XPs')
  
 SELECT 
       name,description,
	   CASE WHEN  value = 0   THEN 'Passed'
	   WHEN  value = 1   and name= 'Default Trace Enabled'  THEN 'Passed'
	   ELSE 'FAILED'  END AS CIS_SQL_Configuration_Status 
  FROM ##configurations 

  SET NOCOUNT OFF;

Select allOpen in new window

Document2.xlsx