Hi All, can someone help me with a solution, I am able to solve for one column merge but in my case I want 2 columns and rows to be merged,
Ex- Input : this is the data which I got after using cross tab, after this I want my output.
Internal/External Action Criteria Count
External Keep A- Rise 96
External Keep A- Dawn 494
External Remove A-Rise 20
External Remove A-Dawn 38
Internal Keep A- Rise 94
Internal Keep A- Dawn 370
Internal Remove A- Rise 16
Internal Remove A- Dawn 37
Output:
Internal/External Action Criteria Count
External Keep A-Rise 96
A-Dawn 494
Remove A-Rise 20
A-Dawn 38
Internal Keep A-Rise 94
A- Dawn 370
Remove A-Rise 16
A- Dawn 37
Can anyone help me with this output?
Solved! Go to Solution.
Hi @DataNath , removing the headers will lead to my output, could you please share the flow with me ?
Sure @Kaish - here you go.
if you want to re-enable headers, just use this option:
For reference, this method works by constructing tables inside tables, which are grouped by the level above and therefore appearing as 'merged' column values.
Hi @DataNath thank you for your support I was able to find out the solution, @OllieClarke thanks for the reply and solution but when I was working with my data it was having some loopholes due to null data values, anyways thank you for your support.