Turn part of a list into a table

[richardallen]

Hi, I am trying to turn a text list into a table. The list is approx 60 'routes' as similar to below. I would like use a macro to turn this into a 60 row table.

What is the best was of achieving this?

Many thanks,
Rich


From a text list:

Route *TEST_AD*​

User 1 name: Business Unit​

User 2 name: Invoice No.​

User 3 name: Supplier​

User 4 name: Transaction Value​

User 5 name: Invoice / Credit​

User 6 name: Due Date​

User 7 name: Approval Value (Base)​

User 8 name: Purchase Order No​

​

State 1 : Cody​

Goto State (2) MW\Andy.Donald When Response = Accept​

Change Route ~ Rejected When Response = Reject​

Query State When Response = Query​

State 2 : MW\Andy.Donald​

Change Route ~ Authorised When Response = Accept AND User 7: Approval Value (Base) <= 10000​

Goto State (3) MW\Richard.A When Response = Accept AND User 7: Approval Value (Base) > 10000​

Change Route ~ Rejected When Response = Reject​

Query State When Response = Query​

State 3 : MW\Richard.A​

Change Route ~ Authorised When Response = Accept​

Change Route ~ Rejected When Response = Reject​

Query State When Response = Query​

To a table:
Routename | State1 | State2 | State3 | State4 | State1 Value | State2 Value | State3 Value | State4 Value
Route *TEST_AD* | Cody | Andy.Donald | Richard.A | blank | 0 | 10000 | 0 | 0