My data is in below format:
General instructions: | ||||||||
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column 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 B | Column C | Column D | Column E | Column F | Column G | Column H | Column I |
Please let me know if there is a solution for this.
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.
You can transform this workflow into a macro and process them one by one or within a batch macro.
User | Count |
---|---|
16 | |
14 | |
11 | |
6 | |
6 |