Read More:VBA to Transpose Multiple Columns into Rows in Excel (2 Methods) Method 3 – Use the Power Query Tool In this section of the article, we’ll be working with a dataset that differs from the one we’ve used so far. Our dataset contains product names, sizes, and quantities in ...
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...