Hi Team,
I have the below data and want to repeat header (First 2 rows for each Org row). Output required shown below.
Input data shared in excel as an attachment.
Can we achieve this in Alteryx Designer?
Input:
Org | Particulars | Val1 | Val2 | Val3 | Val4 | Val5 |
Check 1 | ||||||
A | Over-writing records | 1 | 2 | 3 | 4 | 5 |
B | Over-writing records | 11 | 12 | 13 | 14 | 15 |
C | Over-writing records | 21 | 22 | 23 | 24 | 25 |
Output:
A | Org | Particulars | Val1 | Val2 | Val3 | Val4 | Val5 |
A | A | Check 1 | |||||
A | A | Over-writing records | 1 | 2 | 3 | 4 | 5 |
B | Org | Particulars | Val1 | Val2 | Val3 | Val4 | Val5 |
B | B | Check 1 | |||||
B | B | Over-writing records | 11 | 12 | 13 | 14 | 15 |
C | Org | Particulars | Val1 | Val2 | Val3 | Val4 | Val5 |
C | C | Check 1 | |||||
C | C | Over-writing records | 21 | 22 | 23 | 24 | 25 |
Thanks for the solution, @Felipe_Ribeir0