How to get pivoted data from handsontable?

Tags: #<Tag:0x00007efc649e1490>
#1

Hi,

I have a handsontable with period as dynamic column and need to pivot while retrieving data from it.

eg. sample columns Name, age, id, 2020, 2021,2022,2023,2024 etc
pivoted value should be {name, age, id, 2020}, {name, age, id, 2021}, {name, age, id, 2022} etc.

Do we have anything without looping?

#2

Hi @aswram23

we have a helper for switching columns with rows but in this structure

image

you would need a loop to gather the data.

#3