Set Sr_Rng = Application.InputBox(Prompt:="Mark the range to flip", Title:="ExcelDemy: Transpose Tool", Type:=8) Set Dst_Rng = Application.InputBox(Prompt:="Mark the cell where you want to place the transposed range", Title:="ExcelDemy: Transpose Tool", Type:=8) Sr_Rng.Copy Dst...
Because we want the results to be listed “left to right”, we will place the UNIQUE function inside a TRANSPOSE function to perform the “flip”. Select cell F2 and enter the following formula: =TRANSPOSE(UNIQUE(TProject[Department])) As before, you can also integrate the SORT function in...
(i.e.cell B4.) Go to the Data tab. Click on From Table/Range on the Get & Transform Data group.The Create Table dialog box opens.Click OK. The Power Query Editor window will open.Go to the Transform tab. Select Use Headers as First Row.Click Transpose....