How to create Excel with grouped Rows - Similar to the Excel Group function

Hello!

I am looking to create an excel output of my data where the data is grouped by rows. I can't seem to find this functionality in alteryx the same way excel handles it. I want to take the current Alteryx output of my data:

And transform it in Alteryx to output this:

So when collapsed it should look like this:

I want to assume row1 is the headers and the rows are grouped by employee ID, with the first record of the ID displaying as the "sample" line. Is there anyway to do this in Alteryx?

Thank you!

Workflow

Reporting

Tips and Tricks

Accepted answers

CharlieS

@AlteryxTrev

That's correct, adding the grouping functionality is not a supported function. However, there have been some developments in Excel support. Mainly, the "Preserve Formatting on Overwrite" is available when writing to a specific range of cells in Excel. This means that if you are updating a range of cells that has grouping enabled and the arrangement of your data is identical, it should retain that function in Excel.*

https://help.alteryx.com/20214/designer/file-format-options

*I have not tested this myself, Let me know how it goes!

All comments

CharlieS

Hi @cdushel

That group formatting feature is not supported in the Alteryx Reporting tools. It may be possible to add that formatting after you have written the file using VBS, Cscript.exe, and the Run Command tool, but this could get very complex.

cdushel

Is there possibly a series of tools you could use to arrive at the same solution? Even though there isn't one button or function for it?

AlteryxTrev

@CharlieS Since it has been two years since this question was asked, is this still the case where this functionality is unavailable? If so, is the best way to just perform this grouping/collapsing directly in Excel?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703