Forum Discussion

li chen's avatar
li chen
Copper Contributor
May 05, 2018

Transforming Data Table

 Have a sheet of data as below Col1/ Col2...NN   Col1 (Txt)           Col 2..NN ----------              -- -- -- -- --  abc c1:v1            5   23   102 xyz  cx:vz          23   101 5    vav  c...
excel
Gourab Dasgupta's avatar
Gourab Dasgupta
Iron Contributor
May 05, 2018

Hi

Hope this will help you.

https://support.office.com/en-us/article/TRANSPOSE-function-ED039415-ED8A-4A81-93E9-4B6DFAC76027