Macro/UDF to auto Transpose cells

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello and greetings!
I am stuck in a list of my team members more than 2000 where details for every individual is not recorded based on fields/columns but is keprt rows.

For example [sheet 1] contains
Cell reference a1 contains Name1
Cell reference a2 contains department1
Cell reference a3 contains phone1
Cell reference a4 contains email1
Cell reference a5 contains url1


Cell reference c1 contains Name2
Cell reference c2 contains department2
Cell reference c3 contains phone2
Cell reference c4 contains email2

Cell reference a7 contains Name3
Cell reference a8 contains department3
Cell reference a9 contains phone3
Cell reference a10 contains email3
Cell reference a11 contains url3

In output [sheet 2] should contains only three rows:
Cell reference a1 contain Name1, b1 contain department1, c1 contain phone1, d1 contain email1 and e1 contain url1
Cell reference a2 contain Name2, b2 contain department2, c2 contain phone2, d2 contain email2
Cell reference a3 contain Name3, b3 contain department3, c3 contain phone3, d3 contain email3 and e3 contain url3

Note: In this list there is a empty/blank cell between two contact details.

An immediate attention towards this request would be highly appreciated.

Thank you best Regards - AJ


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
could you upload a sample workbook with some sample data on some public file sharing site and post back the link to the FILE back here
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month