Trying to concatenate rows based on pattern

[Inactive User]

I know how to concatenate based on same column name but Im trying do something a little different,

Here is how my table looks like right now

Order details	1.1  ~~~Info~~
Order details	1.2 ~~~Info~~
Order details	2.1 ~~~Info~~
Order details	1.1 ~~~Info~~
Order details	1.2 ~~~Info~~
Order details	1.3 ~~~Info~~
Order details	1.4 ~~~Info~~
Order details	2.1 ~~~Info~~
Order details	3.1 ~~~Info~~
Order details	1.1 ~~~Info~~

This is my desired output. Basically I would like all related details in the same cell as opposed to all in different ones. So order details (1.1 - 1.1] ,with the second 1.1 being exclusive, be in the same cell. Thank you any help would be much appreciated. 

Order  details	1.1 ~~~Info~~ 1.2 ~~~Info~~ 2.1 ~~~Info~~
Order  details	1.1 ~~~Info~~ 1.2 ~~~Info~~ 1.3 ~~~Info~~ 1.4 ~~~Info~~ 2.1 ~~~Info~~ 3.1 ~~~Info~~
Order  details	1.1 ~~~Info~~

[MarqueeCrew · Accepted solution]

@Inactive User,

You'll want to sit down for this.  First, create a rowID based upon 1.1.  Second Summarize and concatenate using \n (newline).  Third, drop the rowID.  You're done.

Want to see this in a video?  @TuvyL thought so ...

Cheers,

Mark

[TuvyL]

Absolutely loved this! Thank you @MarqueeCrew!

[Inactive User]

 @MarqueeCrew Just saw you added a video. You are a legend, watching that really helped me understand the workflow a lot better! I can only hope to be at your level one day, thank you!

[MarqueeCrew]

@Inactive User ,

my pleasure and thanks for the compliment. Perhaps you be answering challenged here soon enough. 

cheers,

 Mark