How to separate rows of a table based on unique value on a column

Hi Friends, 

I have below tables 

KEYSTYLEDESCRIPTION
1A1
2A2
3B3
4B4

Could you guys advise me how to separate it with <<Start>> <<End>> expression to below 2 thinner tables ? ( I'm trying to do this for Email Body Template )

STYLE : A

KEYDESCRIPTION
11
22

 

STLYE : B

KEYDESCRIPTION
33
44
Solved Solved
0 7 308
1 ACCEPTED SOLUTION

Assuming the table is called "Styles":


<<Start:

FILTER(
  Styles,
  [_RowNumber]=
  MAX(
    SELECT(
      Styles[_RowNumber],
      [Style]=[_THISROW-1].[Style]
    )
  )
)
>>

Style: <<Style>>

KeyDescription
<<Start:
FILTER(
  Styles,
  [Style]=[_THISROW].[Style]
)
>><<Key>>
<<Description>><<End>>

<<End>>

Please change [_THISROW] with [_THISROW-1] on either expression if it doesn't work, I tend to forget the logit sometimes about it's usage. And I found it unreliable sometimes

View solution in original post

7 REPLIES 7
Top Labels in this Space