Output to Adjacent Fields after Consecutive Values' Changes

[HomesickSurfer]

Hi

Perhaps I'm overthinking this...need some help please.

How can I achieve this...

TIE

P

TIE

B

P

B

P

B

TIE

B

P

B

P

B

P

B

B

P

B

B

from this?:

WINNING HAND

TIE

P

TIE

B

P

P

P

B

P

B

TIE

B

B

B

B

P

B

P

B

B

[Luke_C · Accepted solution]

Hi @HomesickSurfer 

This was a fun one, here's an approach that should work:

1. Multirow to find consecutive values
2. Tile Tool to assign ordering of columns (grouped so the same order/ID is assigned to each repeated value)
3. Crosstab
4. Dynamic rename to update columns to use the winning hand value
   1. Note: You can't have columns that have the same names, so you'll see Tie, Tie2, etc. 

[HomesickSurfer]

Thank you @Luke_C 

This is perfect!  Fun challenge...

I'm good with the prefixed field names because I intend to exclude them in my table's output.

Thx so much.