Columns to Rows

Occasional Visitor

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

1 Reply



That would not possible since there is nothing in the source data that represents the output data in line 3 and in line 8.


Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies