Forum Discussion
Pivot Columns in Grouped Data (Having Nested Tables)
Hi guys, I seek your usual support to advise how may I sort this challenge. As per the below, I got some data grouped to get me the attendance figures of each month for each employee distribu...
In this situation, because all but one of the columns is involved, you could probably add an index column before your pivot. Then Duplicate that table, and choose just the index and nested table column. Back to the first table, remove the nested table column. Do your pivot. Then use the Merge GUI function and join the 1st and second table. That should do it!
--Nate