Hi guys,
Newbie here.
I have 2 columns wherein there are urls in each cell up to 300 rows. Urls 1 can be found in column W and the other url is in X. The name of the sheet is Source. What i wanted to achieve is to use the web query tool to extract the details to column Z and AE.
Thank you.
Newbie here.
I have 2 columns wherein there are urls in each cell up to 300 rows. Urls 1 can be found in column W and the other url is in X. The name of the sheet is Source. What i wanted to achieve is to use the web query tool to extract the details to column Z and AE.
- Column W2 extract to Column Z2
- Column X2 extract to Column AE2.
- Return blank result if urls are not found in specific cell in column w and x.
Thank you.
