I want to look for a particular word in an excel file and make it header and the rest as data of the table. For example, i have rows like below
I want to look for Item No. and make it as a column and the data below it, i.e. 300UT95N and 300UT95N to be the data rows for Item No. Description as another column and 9.5 ULT W and 9.5 ULT W
as data rows for Description column.
read range , a
for each row activity and a
switch activity inside for each for checking a set of words. Now I want the data to be added as rows in different columns. Not sure if my approach is right.
I have attached the workflow and the excel file. Help would be appreciated.
invoice.xlsx (8.1 KB)
new scraping.xaml (8.8 KB)