Forum Discussion
Rathish2465
Jan 15, 2019Copper Contributor
Columns to Rows
hi all
I have the following data in my excel. My requirement is
Contract No | Name | Address | Code1 | Code2 | Code3 | Code4 |
1 xxxdf dfdff A B D
2 yyysd tyyhj B C A A
I need the output as
Contract No | Name | Address | Code |
1 xxxdf dfdff A
1 xxxdf dfdff B
1 xxxdf dfdff C
1 xxxdf dfdff D
2 yyysd tyyhj B
2 yyysd tyyhj C
2 yyysd tyyhj A
2 yyysd tyyhj D
please suggest
- Detlef_LewinSilver Contributor
Hello
That would not possible since there is nothing in the source data that represents the output data in line 3 and in line 8.