Re: Arrange horizontal data to be vertical

[markland]

Hi all,

Sorry to re-post again because i forgot put a sample file in last times.

I would like formula to rearrange multiple data in horizontal to vertical for my stock management.

Please find the attachment

Thank you in advance Book2.xlsx

[samba_ravi]

Created a helper column H
H2

Please Login or Register  to view this content.

Try this formula and copy towards down up to H10 then
A15

Please Login or Register  to view this content.

B15

Please Login or Register  to view this content.

C15

Please Login or Register  to view this content.

Try the above and copy towards down
see the attached file

[markland]

It's great

Thank Siva