Workflow's Excel Output: Skip Row When Col-A Value Changes

Question

Hi:

I have simple need; hopefully Alteryx can do it. I an sending my workflow's data to Excel but I need the output to add a blank row when the value in Column A changes. This would be a normal feature of a Pivot Table, but I need the raw output to have the blank rows.
Here is what I'm looking to do. 
Thank you!

This is the regular output:MakeAcuraToyotaToyotaHondaHonda

Sample of what I'm looking for:MakeAcura ToyotaToyota HondaHonda

flying008 · Answer

Hi, @charlieepes

FYI.

Another way:

Spoiler

IIF([Make]!=[Row+1:Make] && !IsEmpty([Row+1:Make]), [Make] + ', ', [Make])

******

If can help you get your want, please mark it as a solution and give a like for more share.

oyes2704 · Answer

Hi @charlieepes ,

I made a very dummy workflow inserting a record with the number last in the block +1/2.

1. Creating recordIds

2. Taking last record of the group

3. Updating the recordID with +0.5

4. Union back to the main table

5. Sorting by Record ID

Please see the solution package attached.

Enjoy!

Oly

Make_EmptyRow.yxzp