Greetings All,

Thank you to all the forum members and forum moderators for providing a platform to take help and support.

I am working on a project where different tools generate different reports and each report has one unique column header.

For Example:
Application-1 generates a report of all Physical Servers
Application-2 generates a report of all clusters where a group of Physical Servers are grouped
Application-3 generates a report of all applications using a particular Physical Server
Application-4 generates a report of all instances of DB, other SQL items in a particular Physical Server

Objective:
Consolidate all the information in one report based on let us say for now "Physical Server".

Detailed description:

I have three spreadsheets:
  1. Sheet-1 in Spreadsheet-1 has 5 columns
  2. Sheet-1 in Spreadsheet-2 has 5 columns
  3. Sheet-1 in Spreadsheet-3 has 5 columns

Server name is the column (Primary Key) available in all the above Sheets

In Spreadsheet-1, we have unique rows with one of the column as Server Name
In Spreadsheet-2, we have multiple rows with one of the column as Server Name
In Spreadsheet-3, we have multiple rows with one of the column as Server Name

Example:
  • Spreadsheet-1 has One rows with Server Name as ABC123
  • Spreadsheet-2 has Three rows with server Name as ABC123
  • Spreadsheet-3 has Five rows with Server Name as ABC123

Result:
Sheet-1 in Spreadsheet-4 will have the below:
1. 9 rows with all the columns from all the spreadsheets (15 Columns) where Primary Key was Server Name
2. The column headers and values are appended by sheet wise
3. After the 9th row, the values will be for a different primary key

Attached is the spreadsheet where input sheets and the result sheet sample can be seen.
Your help will mean a lot to me and will save a lot of man hours.

Problem Statement.xlsx