Json modern sharepoint list

Hi vaibhavk665 

i understand that you want to transpose your list and that you want to display the list rows als columns and the list columns as rows.
This is not really possible with list formatting alone, but you can kind of simulate that.

If you have a list "Amounts"

 then you can switch the view to gallery mode

 
And you get this

Now we display all list items as cards next to each other. If you add another year, then the new card will be added on the right. But if there is not enough space, then the card will be pushed to the next row. So we cannot add an endless number of years there.

But we can style these cards using json formatting to make them look more like a transposed table.

But if you want to be able to add an endless number of years to the list and they all must be displayed as columns (and not flow into the next row) then this is not possible with list formatting. You should create a Power BI Report in that case and embed that on your SharePoint Site.

Best Regards,
Sven