Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 1194 points

Kui

Favorite Answers33%
Answers3

  • How to call out scattered rows but the same data and rearrange them. (Excel)?

    I have 2 arrays of data and it's like this

    Array 1:

    ID Data1 Data2

    1 23 34

    2 212 32

    3 35 56

    Array 2:

    ID Data 3 Data 4

    3 123 345

    2 324 34

    4 12 32

    How to rearrange it and let it to look like this?

    ID Data 1 Data 2 Data 3 Data 4

    1 23 34

    2 212 32 325 34

    3 35 56 123 345

    4 12 32

    (By using MS Excel)

    Thanks a lot.

    If you answer that this can only be done with VBA, please I need the code. Thank You.

    2 AnswersSoftware8 years ago