VTC function splits columns automatically, if you want to specify fixed columns, use IN function. VTC function allows to shorten the formula and create high flexibility when creating dynamic reports in Excel.
Detailed video instructions:
You are here
Execute SQL in Excel and create dynamic report 
Create report with column split combining IN and VTC in BS_SQL function
Create report with column split combining IN and VTC in BS_SQL function