I would really appreciate it if someone could help me out. I need to reaarange data present in a column to a row format but its not as easy as just using the transpose function. I think a macro is needed because I want to change the format of the data. Please refer to example below:

Before
Source Target
LH10021 LH10022
LH10021 LH10023
LH10021 LH10041
LH10021 LH10051
LH10021 LH10053
LH10021 LH10251
LH10021 LH10252
LH10021 LH10352
LH10021 LH10353
LH10021 LH10722
LH10021 LH11072
LH10022 LH10021
LH10022 LH10023
LH10022 LH10031
LH10022 LH10041
LH10022 LH10043
LH10022 LH10053
LH10022 LH10061
LH10022 LH10063
LH10022 LH10081
LH10022 LH10032
LH10023 LH10021
LH10023 LH10022
LH10023 LH10031
LH10023 LH10033
LH10023 LH10043
LH10023 LH10091
LH10023 LH10252
LH10023 LH10531
LH10023 LH10251
LH10023 LH10532

After
LH10021 LH10022 LH10023 LH10041 LH10051 LH10053 LH10251 LH10252 LH10352 LH10353 LH10722 LH11072
LH10022 LH10021 LH10023 LH10031 LH10041 LH10043 LH10053 LH10061 LH10063 LH10081 LH10032
LH10023 LH10021 LH10022 LH10031 LH10033 LH10043 LH10091 LH10252 LH10531 LH10251 LH10532

As you can see formatting the data as such would require me to transpose the data and then delete all the rows from which the data was transposed. The number of source cells is much more than shown in the example also the number of target cells varies for each source cell so a standard macro would not suffice. If I did this manually it would take me a few days.

If someone could please provide for a macro which can help me out or help me in writing one. Thank you all.

ZeroKalvin