Converting a single row data into multiple Row Data

[kumark]

Hi All,

I need to convert a single row data into multiple Row Data. Please Find the Attached Excel for the Reference.



Regards
Kumar

[PCI]

Is there a fix number of account number?

[PCI]

If yes see next code

Please Login or Register  to view this content.

[jindon]

No fixed columns.

Please Login or Register  to view this content.

[kumark]

Many Thanks!!!!!!! it worked thank you guys for your help

[kumark]

Hi jindon,

If there are many columns towards your right Side

b(n, 6) = a(n, UBound(a, 2) - 1)
b(n, 7) = a(1, UBound(a, 2))

if there is another 8-10 columns more on the right side . how to loop

[kumark]

Hi jindon,

If there are many columns towards your right Side

b(n, 6) = a(n, UBound(a, 2) - 1)
b(n, 7) = a(1, UBound(a, 2))

if there is another 8-10 columns more on the right side . how to loop

[jindon]

Need to see your workbook and the result that you want.

[kumark]

Please Refer the File for Understanding

[jindon]

Adjust Acc if needed.

Please Login or Register  to view this content.

[kumark]

I have updated the file for your Reference. Work with Code.xlsm

[jindon]

Please Login or Register  to view this content.

[kumark]

Thanks jindon... Thank You so Much ..it Worked Great ... Appreciate your Help and Patience
Thanks alot Bro...

You Rock