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.
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'