Grouping by data section

Moe-Sado

Hi,

I would like to know how I can group in alteryx the data corresponding to the VAT identification section in a new column.

As seen in the following table:

Previous information
DATA	FIELD_1
VAT ID	123
COMPANY	Example Co.
DATE	2017-04-30
SALES	10
VAT ID	234
COMPANY	Example INC.
DATE	2017-05-30
SALES	11
PURCHASES	3
VAT ID	123
COMPANY	Example Corp.
DATE	2017-07-30

Desired information
DATA	FIELD_1	GROUP
VAT ID	123	1
COMPANY	Example Co.	1
DATE	2017-04-30	1
SALES	10	1
VAT ID	234	2
COMPANY	Example INC.	2
DATE	2017-05-30	2
SALES	11	2
PURCHASES	3	2
VAT ID	123	3
COMPANY	Example Corp.	3
DATE	2017-07-30	3

Luke_C

Hi @Moe-Sado 

here's an example using the multi-row formula tool. It looks to see if the value is VAT ID, if it is, then it adds 1 to the group, otherwise repeats the previous group number.

New Workflow3.yxmd