I have a table something like this
Row 10 (not fixed) gives the total of the values in that column
Number of values in a column can differ
Requirement 1 :- Fetch the total when there are blank rows in b/w [column 2]
Requirement 2 :- If total doesn’t exist then calculate the total [column 1]
Requirement 3 :- Calculate or fetch the total (if it exists) when there are no blank rows in b/w [column 3]
Is there an activity to get column letter based on column name ?
Ignore the colours - they are not fixed
Column headers are present in Row 2 and the header names are fixed but column index can change from file to file
Kindly help me with this.