Thursday, August 30, 2012

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

user sanjeev.kulshreshtha said: (!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