Hi,
I am using Aspose. cells I am looking for Transposing the data from vertical to horizontal based on the following criteria.
Input CSV:
Column1,column2,column3,colum4,column5,column6
1,2,1,XXX,name1, value1
1,2,1,XXX,name2, value2
1,2,1,XXX,name3, value3
1,4,5,YYY,name1,value1
1,4,5,YYY,name2,value2
1,4,5,YYY,name3,value3
1,4,5,YYY,name4,value4
2,3,4,ZZZ,name1,value1
2,3,4,ZZZ,name4,value4
Output CSV:
Column1,column2,column3,Name1,name2,name3,name4
1,2,1,XXX,value1,value2,value3,
1,4,5,YYY,value1,value2,value3,Value4
2,3,4,ZZZ,value1,Value4
In this case, column 1, colum2, column3 are repeating. The number of meta columns needs to be passed as a parameter need to be dynamic as input to the code. It can be 6 columns always the last two columns are transposed to Vertical and other repeating meta-information is removed and added as one entry
Example: Please look at the image below on what needs to be accomplished
image.png (14.1 KB)
Any direction or help would be appreciated!