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:
- Sheet-1 in Spreadsheet-1 has 5 columns
- Sheet-1 in Spreadsheet-2 has 5 columns
- 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
Bookmarks