How to parse into a new column an account number from the column

[Dprado006]

Hi Community.

First time posting here, hoping for your assistance. I have a large data set from an accounting ledger where the first column has the Client number and the journal, Below an example: 

Numer/Journal	Client/Description	Credit	Debit
123445	John Smith
JD9474	Description of purchase	1
JP8430	Description of purchase		1
JD9384	Description of purchase	1
903490	Martha Smith
JP9384	Description of purchase		1
JP9345	Description of purchase		1

What I want is to parse the client number and client name to a diferent column each but added to each record to know to which client the record belongs to, ti should look something like this:

Number	Client	Journal	Description	Credit	Debit
123445	John Smith	JD9474	Description of purchase	1
123445	John Smith	JP8430	Description of purchase		1
123445	John Smith	JD9384	Description of purchase	1
903490	Martha Smith	JP9384	Description of purchase		1
903490	Martha Smith	JP9345	Description of purchase		1

Many thanks in advance.

[ChrisTX]

Is the value for Number always only numbers, no letters?

Does the value for Journal always start with a capital J?

[Dprado006]

Hi Chris, the client number is only numbers and there can be records that start with a capital J or P

[ChrisTX · Accepted solution]

Attached is one option

 

Chris

[Dprado006]

Thank you! it worked.