How Convert Excel Data in Following Format

Covert the excel sheet data in this format to the below format using uipath

Can you explain what you want?

If it is to write into the excel file in this format,you can use the following sequence.

Main.xaml (6.4 KB)

I want to convert in the format like this

What do you want to convert in this format?

Normal excel file data to formatted table

Read data from excel to a data table, add that row into another data table with that structure.
Then write it into the excel doc. Try this sequence.

Main.xaml (9.0 KB)

Thank you :slightly_smiling_face: