---
title: "Display data Column wise"  
description: "Display data Column wise"  
author: "Manmohan Jha"  
published: 2013-09-29  
updated: 2013-09-30  
canonical: https://www.mindstick.com/forum/1574/display-data-column-wise  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# Display data Column wise

Hello developers...\
\
I have some [problem](https://yourviews.mindstick.com/view/81399/tackling-the-problem-of-unemployment-during-corona-pandemic)\
My [Sql table](https://www.mindstick.com/forum/160519/how-can-i-update-sql-table-by-dataset-data-in-ado-dot-net) look like this..\
\
[Session](https://www.mindstick.com/articles/12042/session-in-c-sharp) [Student](https://www.mindstick.com/articles/157138/student-loan-default-wage-garnishment-and-student-loan) Id [Subject](https://yourviews.mindstick.com/view/259/physical-education-a-compulsory-subject-in-school-curriculum) MarksType Marks\
2013-2014 S00001 [Math](https://www.mindstick.com/articles/23293/5-great-marketing-jobs-for-math-geeks) FA1 50\
2013-2014 S00001 Hindi FA1 602013-2014 S00001 English FA1 622013-2014 S00001 Math FA2 55\
2013-2014 S00001 Hindi FA2 622013-2014 S00001 English FA2 70\
\
But i want [print](https://www.mindstick.com/blog/301752/types-of-3d-printing-technology) like this\
\
Session Student Id Subject FA1 FA2\
2013-2014 S00001 Math 50 55\
2013-2014 S00001 Hindi 60 622013-2014 S00001 English 62 70\
\
Help me...\
\
Thx &[amp](https://www.mindstick.com/forum/156207/what-is-amp); regards\
Manmohan Jha

## Replies

### Reply by Manmohan Jha

Query:-\
In Access 2007\
\
TRANSFORM Avg(Marks) as Mrk SELECT Subject FROM StudentsMarks WHERE Session='2013-2014' AND Student Id='S00001' GROUP BY Session_,Student Id, Subject PIVOT MarksType In (FA1, FA2)\
\
How to use same query in [Sql](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database)?


---

Original Source: https://www.mindstick.com/forum/1574/display-data-column-wise

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.