Excel Program

SoccerBoss
Category:
Programming
Price: $10 USD

Question description

Hello Everyone,

I need serious help in defining a program in excel (later to be converted to java myself). My major is Transportation Engineering but I am working on some simulation softwares, I have no good programming background. It'd be highly appreciated if someone answers the question or email me at; atizaz.ali@uos.ac.kr

QUESTION: I have smart card data (excel file) which shows the daily events (boarding, alighting with time etc. for each traveler (unique smart card ID) in one complete row. Most of travelers have more than one daily plans which means each unique ID is repeated in more than 2 or 3 rows (but different boarding station, time etc). What I need is to make a program that automatically converts each unique ID'd all daily plans in one row instead of multiple rows. Any help regarding this would be highly appreciated. Awaiting response!

.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Boston College
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors