Difficult: Display multiple & varied no. of cell data horizontally instead of vertically

Hi,

I am using a large database with ~20k rows.

In this data there is a unique transactional identifier and fields to the right of this that contain information describing the transaction.

What I need to do is display only unique information from these other fields in one row relating to the original unique transaction descriptor - so to move the data from vertical display to a horizontal display whilst only returning unique information.

Attached is an example of what I am after but I lack a formula.

To do this for all transactions manually it will be a very long process. Can anyone help me out with a formula so that the rows can self populate?

Due to the varied amount of column data per transaction I understand I might have to do several different tabs for the different descriptors.

Can anyone help me please?

Thank you!