Computer Science, asked by psm281179, 5 months ago

write the steps to merge a worksheet ​

Answers

Answered by jia1428
1

Answer:

I hope my Answer help you

please mark me brain list

Attachments:
Answered by Anonymous
1

1) Go to the Data tab.

2) In the Get & Transform Data group, click on the ‘Get Data’ option.

3) Go the ‘From Other Sources’ option.

4) Click the ‘Blank Query’ option. This will open the Power Query editor.

5) In the Query editor, type the following formula in the formula bar: =Excel. CurrentWorkbook (). Note that the Power Query formulas are case sensitive, so you need to use the exact formula as mentioned (else you will get an error).

6) Hit the Enter key. This will show you all the table names in the entire workbook (it will also show you the named ranges and/or connections in case it exists in the workbook).

7) [Optional Step] In this example, I want to combine all the tables. If you want to combine specific Excel Tables only, then you can click the drop-down icon in the name header and select the ones you want to combine. Similarly, if you have named ranges or connections, and you only want to combine tables, you can remove those named ranges as well.

8) In the Content header cell, click on the double pointed arrow.

9) Select the columns that you want to combine. If you want to combine all columns, make sure (Select All Columns) is checked.

10) Uncheck the ‘Use original column name as prefix’ option.

11) Click OK.

Similar questions