X-Author for Excel Using Advanced App Design Mapping Records into Columns and Rows Current: Creating a Matrix PDF Download PDF Download page Creating a Matrix. Current page Include child pages All pages Creating a Matrix There is no precise order in which to create a matrix. However, following these steps in order will provide better results.Add your Objects.Decide how you are going to lay out the matrix, including formulas and empty rows and columns.Create your sections and add your empty rows and columns as you go. If any cells are static, add the cell values at anytime.Extend or copy your sections to fill out the matrix using the Extend function.Add Section Filters.Add Display Filters.Add Save Maps.Add actions, action flows, and ribbon menus. ×