How to keep source file format when using query?

Copper Contributor

When using query, the data combined with a table style format.

I want to keep source excel file format e.g. cell color, cell and text format.

 

I am using query with the following steps. (excel 2016)

New query > from file > from folder > combine and edit.

1 Reply
Power Query cannot capture cell styles sorry, the output table could be formatted though