How to extract vendor fields and copy into a separate sheet?

I am currently doing a data migration and I encounter issue how to convert the master data from the legacy system in Picture 1 to Picture 2.

The bot needs to loop through the entire sheet.

For the kind assistance of the Gurus in this forum.

@ben_sim1

Welcome to the community

Ideally if you read the data from excel then you can loop theough eqch row and access each column using its column name and can be changed to any mode you want

Cheers