query + excel: In a excel workbook, create new transformed power query sheet with out converting into table

[harivardhan]

In an excel workbook, i want the "sheet1" to be transformed by power query.
- this transformed data should be in a new sheet of same workbook. say "sheet2"
- but the data in sheet 1 should not be converted into table format.


If this is not possible:
how do i create a dynamic replica of a sheet in the same workbook.
example: 'Sheet 1' & 'Sheet 1-copy' are two sheets in a excel workbook.
ANY CHANGES DONE IN "Sheet 1" SHOULD ALSO BE AUTOMATICALLY REFLECT IN "Sheet 1-copy"

 

[pecoflyer]

Hi
one does not have to convert a range to an XL table to use Power query https://exceloffthegrid.com/power-query-import-data/