Selecting delimited data in multiple columns

Daryl

New member
Joined
Aug 30, 2016
Messages
2
Reaction score
0
Points
0
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?
 
Hi Daryl,
This is sub-forum for Power Query, so maybe your topic is in wrong place?
If not, then check the attachment - is that what you want?
Regards
 

Attachments

  • PQ_Status_Unallocated.xlsx
    17.5 KB · Views: 16
Thanks for the quick reply
This looks to be exactly what I need...
Power Query (not power pivot) is indeed what I want to use for this.
 
Back
Top