Breakout Post Codes by State and Category

[hellyars]

Data reshaping help.

I have a list of states.  Each State has 2 Category fields associated with it.  Each Category has a single Post Codes field with all the Post codes delimited by a comma.   Original image and sample table below.  Note State field is merged across the two relevant rows in the original data -- but can't recreate in sample table below (but easy to do in excel)

Desired outcome.  I need a row for each Post Code in this order. State, Category, Post Code.

UPDATE -- I attached the actual data copied from browser to Excel.  Use this as sample.  Thanks.

[PhilipMannering · Accepted solution]

Hi @hellyars 

See the post codes broken out in the example attached,

Ta,

Philip

[hellyars]

Works perfectly.