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
Solved! Go to Solution.
@EN6924 wrote:Hi,
Please check if this works -
Thanks
Data might get shuffled here, getting individual tables and then manually unioning them is what I am looking for.
Thanks for your response.