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
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
Created a helper column H
H2Try this formula and copy towards down up to H10 thenPlease Login or Register to view this content.
A15B15Please Login or Register to view this content.
C15Please Login or Register to view this content.
Try the above and copy towards downPlease Login or Register to view this content.
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
It's great
Thank Siva
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks