Stack Multiple Pivots Tables into Single Excel Output

Question

Hello,

I have multiple pivot tables that I created using the cross tab tool in different parts of a workflow. I would like to take these pivot table and stack them, with some blank rows in between into a single output sheet in excel. Many of the pivot tables contain different column headers. I have attached sample data as well as the desired output in excel for reference.

Pivot Table - Intended Solution.xlsx

Pivot Table Question.yxmd

PeterA · Accepted Answer

Attached is a quick solution, but do check out the Table & Render Tools on the tool mastery section. (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593)... and if you want to change that first line of data into a proper header check out the dynamic rename capabilities(https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Rename/ta-p/32920)

Spoiler

Workflow
output

PeterA · Accepted Answer

@jfsiegried There is.  Check out the REPORT TEXT function.  You can attach it to the table prior to your render.  See Screenshot below:

adding title to report elements