Excel output manipulation

Question

My data is in below format:

General instructions:  Column AColumn BColumn CColumn DColumn EColumn FColumn GColumn HColumn I

A1 has some text. Row 2 is where my columns are. I want my output in below format. If I use a select tool and uncheck Column A, my General instructions text will not be present in my output. Is there a way I can just remove column A data and get below output.

General instructions: Column BColumn CColumn DColumn EColumn FColumn GColumn HColumn I

Please let me know if there is a solution for this.

niklas_greilinger · Answer

You can transform this workflow into a macro and process them one by one or within a batch macro.

poornimak · Answer

Thank you @niklas_greilinger . This will work for me.

How can I process the same if I have multiple files to work with. My files are in .xlsx.

niklas_greilinger · Answer

Hello,
would this be a suitable solution for you? Workflow is attached.

poornimak_example.yxmd