I am scraping row-oriented data from 2 links (2 different ids, but same file format). The extracted result looks like this :
I need to transpose them on excel in order to have the following output:
Name Birthday Address
name_1 birthday_1 Address_1
name_2 birthday_2 Address_2
Could someone please help me solve this issue,
Thank you very much!
Thank you ! It finally worked
I used the ‘Transpose.xaml’ file which was uploaded on the link you gave me.
However, could you please explain why the ‘Column_name’ and ‘Column_number’ are assigned to the following values : ‘Convert.ToChar(65 + modulo).ToString()+Column_Name’ and ‘Convert.ToInt32((Column_Number - modulo) / 26)’
You are welcome . ‘Convert.ToChar(65 + modulo).ToString()+Column_Name’ and ‘Convert.ToInt32((Column_Number - modulo) / 26)’ is use to get the value of column value like Name Birthday and adreess and count the row of value and transpose It’s very simple buddy.
Please make that’s a solution so that our folks will get the info of this query.