Looking for an Automated & Smart Transpose solution

[Gumsolmao]

So currently, per the title, I'm looking to make a smart and relatively automatic transpose system.

So far the only way ive figured out how to do this is with macros, paste special, and a lot of manual work (working on 2,000~ row sheet).

The following example is an example.
All the events belong to A1 but are distributed downwards in a new row. The goal is to have them all in a single row (either in a single cell or adjacent).

A	1	Event 1
		Event 2
		Event 3
B	2	Group 1

All the events belong to A1 but are distributed downwards in a new row. The goal is to have them all in a single row (either in a single cell or adjacent).
The example of how I need them is demonstrate below.

A	1	Event 1	Event 2	Event 3
B	2	Group 1

I have searched far and wide and haven't found anything which solves this bizarre request.

[im.zeeshan]

I'm assuming your data starts from Cell A1.

Just add a row with hyphens to mark the end of the data sheet like;

A	1	Event 1
		Event 2
		Event 3
B	2	Group 1
		Group 2
-	-	-

Then run the following macro: (Your results will be displayed in Sheet 2)

Please Login or Register  to view this content.

[arlu1201]

Try this code

Please Login or Register  to view this content.

[Gumsolmao]

I swear to god this place is full of witchcraft, thank you both so much.