cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Merge Excel files

Hi, I have a total of 3 Excel files that I would like to merge.

 

All files have a common key column (item no.) but different number of rows.

That is, file 1 can contain rows with item A, B, C and item D.

File 2 can contain rows with items A, C and D and

File 3 can contain rows with items B and D.

 

Each file has different columns that I need in a combined Excel file.

That is, file 1 contains a value column

File 2 contains a quantity column and

File 3 contains a variance column.

 

Aim:

I want to have a single file with rows that show the items and columsn that show the value, quantity and variance.

 

Is that doable with Flow?

 

Best regards,

 

Ludwig

Helpful resources

Announcements
Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,276)