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

[charlieepes]

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:

Make

Acura

Toyota

Toyota

Honda

Honda

Sample of what I'm looking for:

Make

Acura

Toyota

Toyota

Honda

Honda

[oyes2704]

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

[flying008]

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.