# Multiple column values into single column (columns become x axis) **URL:** \ **Category:** Ask for Help\ **Created:** [April 10, 2024, 11:22pm UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472 "2024-04-10T23:22:01Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Matthew\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_viner/32/340_2.png) [@Matthew\_Viner](https://community.glideapps.com/u/Matthew_Viner)\ **Post date:** [April 10, 2024, 11:22pm UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/1 "2024-04-10T23:22:01Z")
Hi Gliders, I’m using a form to capture diagnostic info, it’s binary so “yes” = “1”. The form will show “yes” to user and input a 1 on the sheet. There are 100 questions and 10 categories. I use a Math column to sum the categories. So I have 10 columns, one for each category, with the total score in each. This is all fine. I want to show a chart, with the different categories on the x axis and the values being the score for each category. This would be user-specific, meaning that the signed in user would see their own results only. Is there a way to do this? I feel like maybe a query is possible but still not deft at using it. Thanks in advance, Matt ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 11, 2024, 1:40am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/2 "2024-04-11T01:40:04Z")
Any chance you can show a screen shot of how that looks in the Data Editor? Just having a little trouble visualising it. ---
**Author:** ![Matthew\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_viner/32/340_2.png) [@Matthew\_Viner](https://community.glideapps.com/u/Matthew_Viner)\ **Post date:** [April 11, 2024, 3:44am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/3 "2024-04-11T03:44:33Z")
Thanks for the reply Darren, happy to see you here! Few pics incoming. Perhaps there is a totally different way to acheive this, I can’t work it out. I could have a “Yes” response give the category rather than simply “1” and then count the occasion of the category, but I still have multipe categories (therefore columns) to move into the chart format… Have named images for reference Thanks, Matt ![Desired output](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/1/81102b561804552ffdf9896fb320e7aab0a2ea38.png) ![Into Chart Foramt new table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/696866bf4e77c80826f45364189e49cb3490f010.png) ![Yes is 1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/8418983a13061fb99d74e7d4e90da71e18bb6d42.png) ![Summing 1s](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f56600141bb72187d26601cbe987a6b008a3a867.png) ---
**Author:** ![Matthew\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_viner/32/340_2.png) [@Matthew\_Viner](https://community.glideapps.com/u/Matthew_Viner)\ **Post date:** [April 11, 2024, 3:45am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/4 "2024-04-11T03:45:25Z")
Rows 1-4 are before I set the “yes” form entry to “1”, these can be ignored ---
**Author:** ![Matthew\_Viner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matthew_viner/32/340_2.png) [@Matthew\_Viner](https://community.glideapps.com/u/Matthew_Viner)\ **Post date:** [April 11, 2024, 5:08am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/5 "2024-04-11T05:08:19Z")
This worked for me [https://www.youtube.com/watch?v=t-sh\_Q3WbQc&ab\_channel=RobertPetitto](https://www.youtube.com/watch?v=t-sh_Q3WbQc&ab_channel=RobertPetitto) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 11, 2024, 5:53am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/6 "2024-04-11T05:53:39Z")
Yes, that’s what I was going to suggest. Just wanted to make sure I correctly understood how your data was laid out. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 18, 2024, 5:54am UTC](https://community.glideapps.com/t/multiple-column-values-into-single-column-columns-become-x-axis/72472/7 "2024-04-18T05:54:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.