Get & Transform vs Conditional Format

Question

I am trying to use conditional formattingto output a query Get & Transform. (Office 365 / Excel 2016 32 bit, Windows 10 Pro 64 bit).

However, when the request is updated, instead of Conditional formatting, just extensible / compressed, to affect the changed column, it gets fubar'd, as shown below.

I know that I can get the desired result in various ways, including VBA, and I do not need help in developing other methods.

I don’t notice anything in the user interface, or perhaps some method that I could implement in Advanced Editorto perform normal CF extension, I could see if a row was just added to the table?

To reproduce the problem:

Basic data

Get & Transform 2-4

, , A1

→

:

.

, CF " " , CF

-, Excel, ? (vba manual)? ( ).

applies to, , . . applies to , , Query .

Answer 1

, ( , , , !).

=COUNTIF($A$2:$A2,$A2)>1

=$A$2:$A$4.

, , my , .