How to get Miscellaneous Transaction Serial Numbers range if the serial numbers are consequetive?

Summary:

I have some report requirement to get the transaction serial numbers as: serial_from, serial_to, and range.

The only source table I have is the serial number only without being in range.

For Example: if the transaction has 10 serial numbers from 1 to 10,

the required is serial_from: 1, serial_to: 10, range: 10.

But what I can get is:

serial_from: 1, serial_to: 1, range: 1,

serial_from: 2, serial_to: 2, range: 1,

serial_from: 3, serial_to: 3, range: 1,

etc. till serial_from: 10, serial_to: 10, range: 1,

The attached Screenshots shows what I get versus what is required.

It is required to get the consequetive serial numbers as ranges.