I need help with unstructured XLSX file (or at least I call it that).
Please note Column J, it is exported to have multiple rows.
When I use normal Read Range activity inside Excel Application Scope it only reads the first Row of that Column (so I only get the value “a” not the rest).
Is there any way that I get all the information together because I have one large Excel file and I don’t know much rows will column J have.
Should I ask the client to try and export the table in only one row?
Example of Table.xlsx (9.6 KB)