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

Attached is one option

Chris

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