Hi,
I need some help in separating some data
I have the following table
Column1-Service Column2 - Status Column 3-Priority
Service1,Service2,Service3 Allocated,allocated,unallocated Med,Med,High
Service1,Service2,Service3 Allocated,unallocated,allocated Med,High,Low
What I need to do is end up with the following
Column1-Service Column2 - Status Column 3-Priority
Service3 unallocated High
Service2 unallocated High
So essentially I need to match the position of the Status of Unallocated with the corresponding position in Service and Priority and remove the extra data.
Is this possible in Power Pivot?
I need some help in separating some data
I have the following table
Column1-Service Column2 - Status Column 3-Priority
Service1,Service2,Service3 Allocated,allocated,unallocated Med,Med,High
Service1,Service2,Service3 Allocated,unallocated,allocated Med,High,Low
What I need to do is end up with the following
Column1-Service Column2 - Status Column 3-Priority
Service3 unallocated High
Service2 unallocated High
So essentially I need to match the position of the Status of Unallocated with the corresponding position in Service and Priority and remove the extra data.
Is this possible in Power Pivot?