How can I copy column names of a table to first row so that when I try to stack (union) it with another table on same excel sheet, I can still see the column names?
Hi @JJJJC
Here is how you can do it.Workflow:
Hope this helps : )
Hi @JJJJC,
Legendary @MarqueeCrew wrote a post about an elegant and simple solution to achieve it!
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Column-headers-as-first-row-of-data/m-p/27798/highlight/true#M11480
Can you sample input and expected output.
Edit: @Emil_Kos yup my approach would also be similar 😅
input1:
input2:
expected output:
Currently, when I try to union the two table by position, I would lose header3 and header4.
Thank you both!
Happy to help : ) @JJJJC Cheers and have a nice day!
