Need a Output on seperate tab for each column header.

Question

I have 2 Input data set for multiple columns, I have to merge the dataset or need the comparison of those two data sets for each column in different tab.

Sample input and Sample Output is provided.

Your help is greatly appreciated.

Regards

Input Dummy.xlsx

Output- Dummy.xlsx

paulfound · Accepted Answer

Hi @Mr_Brown

Think this is what you are after.

using Transpose to pivot and record id to group, join and rename!

Attached a sample workflow.

Let me know how you get on.

OllieClarke · Accepted Answer

Hey @Mr_Brown

This workflow should do what you need

Hope that helps,

Ollie