![]() ![]() =TRANSPOSE(SORT(UNIQUE(TProject))) Step 3: List Associated Persons for each “Project/Department” Combination Select cell F2 and enter the following formula: =TRANSPOSE(UNIQUE(TProject))Īs before, you can also integrate the SORT function into this formula to produce an alphabetically sorted list of departments. Next, We make a list of unique departments using Excel’s UNIQUE function.īecause we want the results to be listed “left to right”, we will place the UNIQUE function inside a TRANSPOSE function to perform the “flip”. =SORT(UNIQUE(TProject)) Step 2: Unique Departments using UNIQUE and TRANSPOSE Select cell E3 and enter the following formula: =UNIQUE(TProject)īONUS FORMULA: If you want your result sorted in alphabetical order, place the previous formula inside a SORT function. The UNIQUE function will reduce the list of Projects into a single unique list. This is accomplished using Excel’s UNIQUE function. We begin by making a list of unique projects. If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so you can quickly pivot your data by dragging fields from the Rows area to the Columns area (or vice versa) in the PivotTable Field List.As the two-way table has 3 main components ( Project, Department, and Person), we will construct the result in 3 steps. You can convert the table to a range first by using the Convert to Range button on the Table tab, or you can use the TRANSPOSE function to rotate the rows and columns. If your data is in an Excel table, the Transpose feature won’t be available. Verify these formulas use absolute references-if they don’t, you can switch between relative and absolute references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. The data you copied will overwrite any data that’s already there.Īfter rotating the data successfully, you can delete the original data. Pick a spot in the worksheet that has enough room to paste your data. Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose. Using the Cut command or CONTROL+X won’t work. Note: Make sure you copy the data to do this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |