Write down to new column if condition is met

[soncoku]

Greetings community.

I'm stuck on a task.

I have a long table a rows and columns.

When I downloaded this list from the platform the data was on and uploaded to alteryx a problem came up.

I have a table of data.

The records of this table I need to separate into groups. (add a new column at the end and write the group name)

The group name is at the beginning of the records.
Example:

col1	col2	col3	col4	col5	col6
Group name 1
asdgsfdg	sfdgsdf	sdgsddfg	gjf	gjf	sfasfs
fgsdfgs	sdgsd	dfgsdfg	sfas	safsf	gjf
gjf	sfasfs	dsfgsd	sadfas	gjf	sfasfs
sdfg	sfdgsdg	dsfgsdg	sdafas	gjf	sfasfs
Group name 2
asdgsfdg	sfdgsdf	sdgsddfg	gjf	gjf	sfasfs
fgsdfgs	sdgsd	dfgsdfg	sfas	safsf	gjf
gjf	sfasfs	dsfgsd	sadfas	gjf	sfasfs
sdfg	sfdgsdg	dsfgsdg	sdafas	gjf	sfasfs

What I want to do is :

col1	col2	col3	col4	col5	col6	Group title
Group name 1
asdgsfdg	sfdgsdf	sdgsddfg	gjf	gjf	gjf	Group name 1
fgsdfgs	sdgsd	dfgsdfg	sfas	safsf	safsf	Group name 1
gjf	sfasfs	dsfgsd	sadfas	gjf	gjf	Group name 1
sdfg	sfdgsdg	dsfgsdg	sdafas	gjf	gjf	Group name 1
Group name 2
asdgsfdg	sfdgsdf	sdgsddfg	gjf	gjf	gjf	Group name 2
fgsdfgs	sdgsd	dfgsdfg	sfas	safsf	safsf	Group name 2
gjf	sfasfs	dsfgsd	sadfas	gjf	gjf	Group name 2
sdfg	sfdgsdg	dsfgsdg	sdafas	gjf	gjf	Group name 2

Any ideas?
I was trying to do something with the multirow formula but no luck.

[Ladarthure · Accepted solution]

here is a solution attached, I just added a data cleansing, and you can do it with as many columns as needed.