Transpose Rows to Columns (Multiple Rows)

[ykobure]

Hello gurus!

I was able to come up with a transposition VBA from a single row (in Sheet2) into 2 columns (in Sheet3) depending on the value in a cell. My problem now is to get the looping to the next row (of Sheet2) and paste the values immediately below the values in Sheet3. The attached Excel file will make it easier for you to understand the challenge I am currently in.

Thanks in advance!

[jindon]

Try

Please Login or Register  to view this content.

[kvsrinivasamurthy]

Here is the modified code.

Please Login or Register  to view this content.

[ykobure]

I tried both of your codes, and they worked perfectly! Thank you @jindon and @kvsrinivasamurthy

Appreciated your help!

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.