Transposing excel



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.

I’m using 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. :slight_smile:

invoice.xlsx (8.1 KB)

new scraping.xaml (8.8 KB)


Tips, you would need to use activities such as Build Data Table (perhaps 1 column to start with) and then Add Data Column to dynamically add your next columns.

Use an assign to change the header name, although if you use Add Data Column you should already know the column header when you create it.