Transform Excel data using SSIS

Ram 1 Reputation point
2021-03-30T13:54:16.773+00:00

Hello,

I have an excel sheet with data scattered across multiple cells. I need to transform the data into another well organized excel using SSIS. Please suggest me a good solution to tackle this.

Ex :

  1. Product 01 - Product Name : A1, Product Cost : B2
  2. Product 02 - Product Name : D3, Product Cost : E3
  3. Product 03 - Product Name : B8, Product Cost : C8

I need to transform this kind of data into the following format.

All products under Row 'A' and corresponding cost values under 'B'

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,649 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions