How to analyse long table format?

I have long format table with columns response_id, question_type, questions and answers. Answers column contains numeric and text value how can I anlysis answers or this survay data? Provide some ideas or documents on how to deal with such long format table and how to analyse it?

Data table fixed header & horizontal scroll – Angular

I’m working on a table that should have a fixed thead during page scrolling, and the table also needs to have a horizontal scroll. To achieve this, I’m cloning the thead of the table upon scrolling and adding the CSS property overflow: auto to it. I then synchronize the horizontal scroll bar of the thead […]