Dynamically Extracting Tables from a single excel sheet and then Union them Manually

Greetings of the day,

I have a very long excel spreadsheet wherein I have multiple tables separated by two blank rows at the end of each table.
I want a way using which I can extract all these tables and union them manually to create a single large table.

I am attaching images of the input and expected output with the spreadsheet input file.

Many thanks in advance for any answers and guidance,
Jashwanth Baba

Input.png

Extract Tables.xlsx

Expected Output.png

Reporting

Accepted answers

binu_acs

@JashwanthK one way of doing this

Union_1212.yxzp

All comments

Chantelb

Hi Jashwanth,

You can easily filter out the blank rows by filtering out the null rows, for example put this in a filter tool: !IsNull([Column1]).

Then it just depends on the layouts of your tables to rename the column headers and filter out the column headers.

Let me know if this helps!

Cheers,

Chantel

PanPP

Hi @JashwanthK

I have provided a sample WF that matches your output.

Hope this helps, if it does please like this post/mark it as a solution.

Sample WF - extract table.yxmd

JashwanthK

Chantelb .The fields are sometimes shuffled, I would want to extract the tables with column names and then configure manual union to build a single table

JashwanthK

I want to dynamically extract the tables, the row count for each sub-table might change.

grazitti_sapna

@JashwanthK , One way of doing this is selecting records using select records tools and then using Union to manually re arrange fields. Pleas find the solution attached and let me know if it helped:

extract table wf.yxmd

JashwanthK

@grazitti_sapna wrote:
@JashwanthK , One way of doing this is selecting records using select records tools and then using Union to manually re arrange fields. Pleas find the solution attached and let me know if it helped: