I have 3 repeated lines vertically, I need them to be unified horizontally.

[BoomerL4D]

I'm working on a spreadsheet in LibreOffice and encountered a challenge I'd like to solve. In column A1, I have a list of numbers that repeat vertically, with various associated data in the same row. However, for better organization and analysis of the data, I'd like to condense all the repeated entries from column A into a single row, arranged horizontally.

For example, if in column A I have the numbers 1, 2, 3 repeated several times, each accompanied by different data in adjacent columns, I would like to group all the repeated entries (1, 2, 3) into a single horizontal row while keeping the associated data organized.
 

Could someone please guide me on how I can accomplish this task in LibreOffice? I appreciate any help or suggestions in advance.

[SpaceGhostC2C]

What you are trying to do is to reshape your dataset from long format to wide format. Try searching how to convert from long to wide in the software you are using.