Use union all to construct your own columns headers
--here is the example:
declare @ProfileName as varchar(100)
SET @ProfileName = 'yourSQLprofilename'
DECLARE @tab CHAR(1) = CHAR(9)
declare @fileName varchar(100)
SET @fileName = 'filename' + convert(varchar(10),getdate(),110) +...