How to move values across a excel sheet

Hi guys,

How to move the values in a cell based on heading?

Example; excelFormat

This is the input file and how to format this to look like this:

excelout

Is there any way we can hard code to move contents from one cell to another.

Thank you.

Hi @batBot

do create a build datatable
use add data row and bind it

Thanks
Ashwin S

Can we do it via hard coding? since this is just a simple example the actual file is larger and complex.

Hi @batBot

On what basis how can you hardcore based on for each

Thanks
Ashwin S