Need help to show Count from multiple columns.

To show the count of distinct names from three columns, you can use the Power Query Editor in Excel. Here are the steps to achieve this:

1. Select the three columns that contain the names and their corresponding counts.
2. Go to the "Transform" tab in the Power Query Editor and select "Unpivot Columns".
3. In the "Unpivot Columns" dialog box, select only the columns that contain the names and their corresponding counts, and click "OK".
4. Rename the "Attribute" column to "Name" and the "Value" column to "Count".
5. Remove any unnecessary columns.
6. In the "Home" tab, click on "Close & Load To".
7. In the "Import Data" dialog box, choose "Only Create Connection" and then click "OK".
8. In the Excel worksheet, go to the "Data" tab and click on "Queries & Connections" to open the "Workbook Connections" dialog box.
9. Right-click on the connection that you just created and select "Load To...".
10. In the "Load To" dialog box, choose "PivotTable Report" and then click "OK".
11. In the "Create PivotTable" dialog box, select the range of the data and choose where you want the PivotTable to be located, and then click "OK".
12. In the PivotTable Fields pane, drag the "Name" field to the Rows area and the "Count" field to the Values area.
13. In the "Value Field Settings" dialog box, select "Distinct Count" as the calculation type, and then click "OK".

By following these steps, you should be able to show the distinct names and their counts from the three columns.