Breaking rows into multiple columns

[rajputakansha]

Hello,

I am trying to split my data that only contains one column into multiple columns based on their names. Here is a sample of the data-

Field1

order=1

Date=1/1/2023

Time=12:00

Period=Jan

Amount[NONE][NONE]100.00

[Null]

order=2

Date=2/1/2023

Time=12:00

Period=Feb

Amount[NONE][NONE]100.00

USD Amount[NONE][NONE]56.00

[Null]

order=3

Date=3/1/2023

Time=12:00

Period=Mar

Amount[NONE][NONE]100.00

Each segment is split with a value [NULL]. Can someone suggest the most efficient way of doing this?

Thankyou 

[SPetrie]

Depending on what you want done with the [NONE][NONE] values, you can use = and [ and delimiters and do a text to column split.

After that, a multi-row to establish a grouping and then a transpose to put them into columns

[NMangera]

@rajputakansha,

if you wanted to remove 'NONE' from the AMount and USD_Amount columns you could use the data cleansing tool to remove punctuation like so:

to leave just the numeric values

[cjaneczko]

Another Take.