Website Data:
Extracted data using table extraction from portal:
Expected output:
Attached the input file & expected output
InputFile.xlsx (10.5 KB)
ExpectedData.xlsx (10.4 KB)
file for our reference
Can you guide to achieve following requirements?
- If two values in “Column-3” then we need only EN value
- If only one value in “Column-3” we can get available value
- If two values in “Column-2 “ (Title) , Can we copy only English title ( only if possible)
- Add two columns “Language” & “tableRowNumber”
- Add the value got from step 1 in Language column.
- Row index +1 value in tableRowNumber column