the table described returns a tabular format of the data:
declare @data table(ID int, date nvarchar(10), Field1 nvarchar(10), Field2 nvarchar(10), Field3 nvarchar(10),Field4 nvarchar(10))
insert into @data
select 1, '10/07/21', '10' ,'30','60','90'union all
select 1, '19/06/21 ', '15','35','65','95' union all
select 1, '29/05/21 ', '20','60','80','100'
select * from @data
result
1 10/07/21 10 30 60 90
1 19/06/21 15 35 65 95
1 29/05/21 20 60 80 100
the result I have to get for my application is instead this
10/07/21 19/06/21 29/05/21
10 15 20
30 35 60
60 65 80
90 95 100
