Forum Discussion
Transpose or Pivot table
Hi Anonymous ,
I believe this is due to the fact that your data configuration provides no relationship between the names for PQ to be able to assign them together on a single row under the new headings.
This thread explains it pretty well, I think:
One user suggests to add an index before performing the pivot which is actually pretty smart as it visualises the problem quite nicely:
You can see where PQ is struggling: it can't correctly allocate two names to the same row as they have no relationsip to one another in the original table.
Pete
Super UserHi Anonymous ,
I believe this is due to the fact that your data configuration provides no relationship between the names for PQ to be able to assign them together on a single row under the new headings.
This thread explains it pretty well, I think:
One user suggests to add an index before performing the pivot which is actually pretty smart as it visualises the problem quite nicely:
You can see where PQ is struggling: it can't correctly allocate two names to the same row as they have no relationsip to one another in the original table.
Pete
Hi
Your right, I need to rethink the problem, thanks for the quick response.