How to get value, inder specific cell, with specific word

Help Studio
,
1

Hi,
from an excel collected after a scraping, in the only column present, I have to take the value under some specific words.

I need value under each cell that contains this value:
“PO Line #”
“Submitted Amt”
“Due Date”
“Actual Completion”

datatable.xlsx (9,0 KB)

In the attached file, in blue I have indicated the column headings, and in Yellow, the value that i need.
(grouped, they are 4 specific values).

the number of lines is variable, so the position is not always the same.

the only constant is the name of the 4 words indicated.

therefore I have to create a new table containing only this data.

Ex:
Po Line | Submitted amt | Due Date | Act Comp |
1 | 1000 Eur |20/4/2018| none |
2 | 23.45eur |9/4/2010 | none |

… …
Any idea?
Thanks

2

these are columns??
@AaronMark

3

Those will be the columns to be precise.

the file was created with a single column, with a variable name.
This column contains those four words, one or more times.
For each time they are present, I have to collect the data written in the cell below.
It would be a good idea to create a new table.

Currently 0.0/5 Stars.
Line #
1
Submission Type
New
PO Line #
1
Item

Ordered Amt
Submitted Amt
559,260.00
Due Date
07/31/19
Actual Completion
None
None
Attachments
Status
None
Line #
2
Submission Type
New
PO Line #
2
Item

Ordered Amt
Submitted Amt
186,420.00
Due Date
08/31/19
Actual Completion
None
None
Attachments
Status
None
Line #
3
Submission Type
New
PO Line #
3

4

I need this result.

PO Line # Submitted Amt Due Date Actual Completion
1 559,260.00 07/31/19 None
2 186,420.00 08/31/19 None
3 35,000.00 08/31/19 None

if open file… you can see value…
Please. any idea??