Seetesh,
I understand that you want to convert rows into columns. In other words, you want to display 100 rows of a single column as a single row with 100 columns. If this is correct, then you require (what is known as) a "pivot" query. If you are using an oracle database (forgive me, I couldn't find that information in your post), then a search of the
Ask Tom Web site -- for the term "pivot" (and possibly also "query") -- should provide you with a solution to your problem.
By the way, it looks like you've been working on this particular issue for the last five months. Does this mean that you guys have a very relaxed, unpressured work environment? (I'm assuing that you're a currently employed software engineer, and that this problem is related to your work.) If it's that laid back, maybe you've got a job for me in your organization?
Good Luck,
Avi.