As i have a excel sheet having data from A to E columns but the the column names are stored row by row in F column. So that I need to fetch the column name from F and store into respective columns. i.e F1 -A1 F2-B1 F3-C1 F4-D1 F5-E1

Loop through column in excel sheet

Yoichi (Yoichi) August 4, 2022, 8:52am 4

Hi,

Is your excel sheet like the following?

if so, the following sample might help you.

Regards,

Topic		Replies	Views
Delete "columns X " due to reading empty columns in Excel file row in a Read Range Activity Studio studio , question , activities_panel	2	850	September 23, 2022
Store the values in columns Studio excel , question	2	514	August 4, 2022
Delete Particular Column Studio studio , question , activities_panel	7	472	March 20, 2023
How to delete columns by name in Excel? Help datatable , excel , studio , question	13	4693	November 19, 2020
Loop on Columns? Help	18	4903	July 18, 2019