parse

[satos001]

hi, how would you extract category values from a field and convert them into a new column. I specifically need to pull out the financial assets and liabilities values and put them into their own field. The data is below, THANKS SO MUCH

F2
Receivables from financial services > 1 year
Other assets: Receivables to related parties >1 year
Other assets: Other assets >1 year
Other assets: Receivables from Family trust >1 year
Raw materials and supplies at warehouse
External
DE-Grass Reinheim
DE-Hetal-Werke
AT-Grass Austria
Work in Progress
External
AT-Grass Austria
Finished goods
External
DE-Grass Reinheim
AT-Grass Austria
Merchandise at warehouse
External
CA-Grass Canada
DE-Grass Reinheim
DE-Hetal-Werke
US-Mock Louis
AT-Grass Austria
Trade receivables
External
Ico
CA-Grass Canada
US-Mock Baer
US-Mock Louis
US-Mock Wood Group
AT-Grass Austria
SE-Grass Sweden
Receivables from financial services <1 year
Income tax receivables
External
US-Wugona
Other assets: Suppliers with debit balance
Other assets: Bonuses/Rebates
External
US-Wugona
Other assets: Receivables to related parties <1 year
External
Other assets: Prepaid expenses
External
Other assets: Other assets <1 year
External
Other assets: Financial derivatives
External
NL-Mock Finance
Other assets: Receivables from Family trust <1 year
Credit Cash-Pooling Mock-Group
Ico
US-Wugona
Distributed dividends
Liabilities from financial services RTM 1-5 years
Liabilities from financial services RTM >5 years
Loans payable and leasing liabilities Mock Group > 1 year
Ico
US-Wugona
Other liabilities: Liabilities to related parties >1 year
Other liabilities: Liab. from holdings of silent partners
Other liabilities: Other liabilities >1 year
Other liabilities: Liabilities to Family trust >1 year
Other liabilities: Purchase price from acquisitions >1 year
Trade payables
External
CA-Grass Canada
DE-Grass Reinheim
DE-marbet
DE-Hetal-Werke
DE-Mock IT
US-Mock Baer
US-Mock Louis
AT-Grass Austria
CN-Grass Shanghai
GB-Grass Great Britain
US-Mock Logistics
US-Northern Safety
US-Wugona
Payments received on accounts of orders
Liabilities from financial services <1 year
Loans payable, leas.liabilities Mock Group RTM < 1 year
Liabilities relating to income taxes
External

[binuacs]

@satos001 Can you provide the expected result?

[satos001]

CATEGORY

Other liabilities: Purchase price from acquisitions <1 year
Other liabilities: Purchase price from acquisitions <1 year
Other liabilities: Purchase price from acquisitions <1 year
Other liabilities: Liabilities to Family trust <1 year
Other liabilities: Liabilities to Family trust <1 year
Other liabilities: Liabilities to Family trust <1 year
Other liabilities: Derivative financial liabilities
Other liabilities: Derivative financial liabilities
Other liabilities: Derivative financial liabilities
Other liabilities: Other liabilities <1 year
Other liabilities: Other liabilities <1 year
Other liabilities: Other liabilities <1 year
Other liabilities:Bill of exchange
Other liabilities:Bill of exchange
Other liabilities:Bill of exchange
Other liabilities: Deferred income
Other liabilities: Deferred income
Other liabilities: Deferred income
Other liabilities: Liabilities to related parties <1 year
Other liabilities: Liabilities to related parties <1 year
Other liabilities: Liabilities to related parties <1 year
Other liabilities: Consulting costs
Other liabilities: Consulting costs
Other liabilities: Consulting costs
Other liabilities: Insurances
Other liabilities: Insurances
Other liabilities: Insurances
Other liabilities: Open vendor invoices
Other liabilities: Open vendor invoices
Other liabilities: Open vendor invoices
Other liabilities: Customers with credit balance
Other liabilities: Customers with credit balance
Other liabilities: Customers with credit balance
Liabilities relating to income taxes
Liabilities relating to income taxes
Liabilities relating to income taxes
Loans payable, leas.liabilities Mock Group RTM < 1 year
Loans payable, leas.liabilities Mock Group RTM < 1 year
Loans payable, leas.liabilities Mock Group RTM < 1 year
Liabilities from financial services <1 year
Liabilities from financial services <1 year
Liabilities from financial services <1 year
Payments received on accounts of orders
Payments received on accounts of orders
Payments received on accounts of orders
Trade payables
Trade payables
Trade payables
Other liabilities: Purchase price from acquisitions >1 year
Other liabilities: Purchase price from acquisitions >1 year
Other liabilities: Purchase price from acquisitions >1 year
Other liabilities: Liabilities to Family trust >1 year
Other liabilities: Liabilities to Family trust >1 year
Other liabilities: Liabilities to Family trust >1 year
Other liabilities: Other liabilities >1 year
Other liabilities: Other liabilities >1 year
Other liabilities: Other liabilities >1 year
Other liabilities: Liab. from holdings of silent partners
Other liabilities: Liab. from holdings of silent partners
Other liabilities: Liab. from holdings of silent partners
Other liabilities: Liabilities to related parties >1 year
Other liabilities: Liabilities to related parties >1 year
Other liabilities: Liabilities to related parties >1 year
Loans payable and leasing liabilities Mock Group > 1 year
Loans payable and leasing liabilities Mock Group > 1 year
Loans payable and leasing liabilities Mock Group > 1 year
Liabilities from financial services RTM >5 years
Liabilities from financial services RTM >5 years
Liabilities from financial services RTM >5 years
Liabilities from financial services RTM 1-5 years
Liabilities from financial services RTM 1-5 years
Liabilities from financial services RTM 1-5 years
Distributed dividends
Distributed dividends
Distributed dividends
Credit Cash-Pooling Mock-Group
Credit Cash-Pooling Mock-Group
Credit Cash-Pooling Mock-Group
Other assets: Receivables from Family trust <1 year
Other assets: Receivables from Family trust <1 year
Other assets: Receivables from Family trust <1 year
Other assets: Financial derivatives
Other assets: Financial derivatives
Other assets: Financial derivatives
Other assets: Other assets <1 year
Other assets: Other assets <1 year
Other assets: Other assets <1 year
Other assets: Prepaid expenses
Other assets: Prepaid expenses
Other assets: Prepaid expenses
Other assets: Receivables to related parties <1 year
Other assets: Receivables to related parties <1 year
Other assets: Receivables to related parties <1 year
Other assets: Bonuses/Rebates
Other assets: Bonuses/Rebates
Other assets: Bonuses/Rebates
Other assets: Suppliers with debit balance
Other assets: Suppliers with debit balance
Other assets: Suppliers with debit balance
Income tax receivables
Income tax receivables
Income tax receivables
Receivables from financial services <1 year
Receivables from financial services <1 year
Receivables from financial services <1 year
Trade receivables
Trade receivables
Trade receivables
Merchandise at warehouse
Merchandise at warehouse
Merchandise at warehouse
Finished goods
Finished goods
Finished goods
Work in Progress
Work in Progress
Work in Progress
Raw materials and supplies at warehouse
Raw materials and supplies at warehouse
Raw materials and supplies at warehouse
Other assets: Receivables from Family trust >1 year
Other assets: Receivables from Family trust >1 year
Other assets: Receivables from Family trust >1 year
Other assets: Other assets >1 year
Other assets: Other assets >1 year
Other assets: Other assets >1 year
Other assets: Receivables to related parties >1 year
Other assets: Receivables to related parties >1 year
Other assets: Receivables to related parties >1 year
Receivables from financial services > 1 year
Receivables from financial services > 1 year
Receivables from financial services > 1 year

[Peachyco]

If you want to convert a single column of data into multiple columns (one column for each value), you're looking for the Cross Tab Tool, under the Transform tab.