Fortunately, it isn’t difficult to transpose column values into a single cell as long as you don’t want to group the results. In that situation, you can use Microsoft Excel Power Query.

Click the query menu (the sheet icon at the intersection of the header rows). From this menu, choose Add Index Column, and then select From 1 from the resulting submenu (Figure D). Figure D ...