Group Line Log For Free

On the Data tab, in the Outline group, click the Group button. Or use the Shift + Alt + Right Arrow shortcut. If you've selected cells rather than entire columns, the Group dialog box will appear asking you to specify exactly what you want grouped. Obviously, you choose Columns and click OK.

To create groups in Power Query, click on Transform tab it will take you to power query editor, select the column on which you want to create a group of range then click on Add Column -> Column From Example -> From Selection.

Use an aggregate function to group by one or more columns Select Group by on the Home tab. Select the Advanced option, so you can select multiple columns to group by. Select the Country column. Select Add grouping.

On the Data tab, in the Outline group, click Group. Then in the Group dialog box, click Rows, and then click OK. Tip: If you select entire rows instead of just the cells, Excel automatically groups by row - the Group dialog box doesn't even open. The outline symbols appear beside the group on the screen.

Select the data (including any summary rows or columns). On the Data tab, in the Outline group, click Group > Group Rows or Group Columns.

How to Merge Rows In Power Query Under Transform>Transpose to transpose the table. Select the first two columns, under Transform>Text column, select Merge Columns, in the prompt, select Space as separator. Under Transform>Transpose, transpose the table back. Regards, Clark.

Select the rows that you wish to collapse, then click on the Data tab and Groups in the Outline group, and then click on Group Rows. You will see a '-' sign on the left of column A. When you click on the '-' sign, the selected rows get collapsed. Now the '-' sign changes to '+' which denotes that the rows are hidden.