Forum Discussion
Solved
Unmerging dataset
Hi there, I have data that is strangely structured like the following: ColumnA ColumnB A B B C and I want to find a way to conver the data to the following...
Following up with this thread that I have solved my issue via merging my table with the same table referencing column B as column A
Hi CHARLEA1 ,
You may try the pivot/unpivot feature.
Input:
Output:
1.Select two columns and click 'Unpivot Columns'.
2.Remove the Attribute column.
3.Remove duplicates.
4.Add an index column.
5.Pivot the Index column. Select 'Don't Aggregate' in the Aggregate Value Function.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.