Automation DataTable Excel

[gilang_mandiri]

hello master, I have difficulty in excel automation. I have Excel containing number data from 1-10 and want to use it as looping data for automated tables in Excel to add the text “Tag” and “Screenshoot” to each column and row. The number of “tags” and “screenshots” corresponds to the number of numeric data in excel(10).

like this is the result I want. and the TagINDEX 0-TagINDEX 9 and ScreenshootINDEX0-Screenshoot 9 are the order of adding text that I mean and want

thanks a lot

[Gautham_Pattabiraman]

Hi @gilang_mandiri ,

It Took some time, But Created a solution. Please check the attached solution for your use case.
ForumQuestion.zip (12.7 KB)

Thanks,
Gautham.