Hi,
I have an excel sheet which contains two colums: ID# (ie ID1, ID2, ID3, ID4) and Workname (every ID has multiple worknames)
In another Excel I have the ID's and worknames in different columns, so every ID is a different column.
If I would load this sheet I would be able to create a group with the different columns to create a hierarchy BUT, I need to have the first excel in order to match other data. Is there a way I can create the hierarchy with the first Excel?
Regards, Paul