yogi_Set Up Formulas To Get A Different View Of The Sheet As Specified By User

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #722   Aug 30, 2012     www.energyefficientbuild.com.

user sanjeev.kulshreshtha said: (http://productforums.google.com/forum/?zx=k7z311txi9j2#!searchin/docs/Compt/docs/e2HRp2Evbtg/6d0OxgxTUYoJ)
query a spreadsheet to generate different view

Hi i have a spreadsheet in following format:

Sn, Train, arr, Days, Compt Company

1,  12622, 22:30, Daily, F1, ABC Co.

2,  12622, 22:30, Daily, F2, XYZ Co.

3,  12622, 22:30, Daily, R1, ABC Co.

4,  12628, 21:15, Daily, F1, PQR Co.

5,  12628, 21:15, Daily, R1, ABC Co.

I would like to conver it in following format:

Sn, Train, arr, Days,  F1, F2,  R1

1,  12622, 22:30, Daily ABC Co, XYZ Co. ABC Co.

2,  12628, 22:30, Daily PQR Co,       , ABC Co.

Let me know how to do this?

is there any function, script or gadgets available?

I have tried query function bit it could not help.

-----------------------------------------------------------------------------

following is my convoluted solution to the problem