Pdf converted to excel and need to format to table.

[sachinsg]

Hi I have converted a pdf to excel and now I am trying to put everything in a table format. I am not be to do so as when I combine regex and text to column I am getting all the data in first column. I have attached the workflow and also I have output format in input file.

Thanks in Advance.

[Qiu]

@sachinsg 

Can you pack your workflow, since we can not see the input file.

[sachinsg]

@Qiu 

Attached now.

[Qiu]

@sachinsg 
Thank you for the input file.

But it is difficult to me, honestly.

When we do RegEx, there should be some patterns.

For your case, what will be difference betwen there two columns?

Domestic cash rate	Gas Rate
Market Open	ABD Multiple
Market Close	EDF Multiple

[sachinsg]

@Qiu 

These are supposed to in two different columns. But when I converted the Pdfs, its all coming in one column with no extra spacing. Also some data should be in column 2 and some in column 3. But since there is no data in column 1, everything is falls in column 1 now. I am finding it difficult to the have them placed in the right column.