Unite identical neighboring rows

[Anonymous]

Hello, 

I would like to combine rows that are identical and neighboring, see example below.  

The order of the entries matters, since they have been listed chronologically. 
Removing duplicates doesn't work, since the blue and grey rows are identical yet not neighboring.

I'd be grateful for any ideas how this could be solved 🙂

Kind regards, 

Jama1234

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Hi

Select all the 3 columns>>>From the Transform Tab>>Group BY.

In the formula bar, just modify the formula by adding the text in red font below

= Table.Group(#"Changed Type", {"ID", "State", "Previous State"},
 {{"ALL", each _, type table [ID=text, State=text, Previous State=text]}},GroupKind.Local)

[Anonymous]

Works perfectly!  Thank you