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 #”
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.
Po Line | Submitted amt | Due Date | Act Comp |
1 | 1000 Eur |20/4/2018| none |
2 | 23.45eur |9/4/2010 | none |