Fetch row excel 3 sheets to 1 sheet

[Harpoon]

fetch row excel with sample data

sheet 1
item st_name st_No class adviser
10 manee 10000056 2 byran

sheet 2
item subject point Grade
20 Mathematics 80 A
20 Data Structure 70 B
20 DataBase 80 A

sheet 3
item schoolteacher
30 Adam
30 Armin
30 Abigail

and i want sheet result like this
10 manee 100056 2 byran
20 Mathematics 80 A
30 Adam
20 Data Structure 70 B
30 Armin
20 DataBase 80 A
30 Abigail

Can someone please explain me or sample screen
Test101.xlsx (11.2 KB)

[aliaga (Ali Aga Mustofa)]

Hi @Harpoon ,

Just want to make sure, could you please confim this output table is order using which column?

Regards,

[Jithesh_R (Jithesh Karkera)]

Hey @Harpoon ,
Please check this workflow
3excelTo1.zip (1.9 KB)

Check the “Output sheet”
Test101.xlsx (12.3 KB)

Hope this helps

[Harpoon]

i can’t open it

[Jithesh_R (Jithesh Karkera)]

Hey @Harpoon
Please refer this screenshot
Input Data Tables are : Sheet1 read range :- DT1
Sheet2 read range :- DT2
Sheet3 read range :- DT3

While doing write range activity please dont tick the add headers as you dont want the headers.

Regards,