Simple Data Formatting

[brem]

Hello Guys!
I have attached my Logon/off information spreadsheet, basically I would like to re-arrange my data into the following format. Is there a way to do it in VB quickly? However, any solution is welcomed. Your kind help is very much appreciated.

Original Data

Username Computer Action Date Time
UserA PC 11 logon 20/07/2010 1:41:01 PM
UserA PC 11 logoff 20/07/2010 1:41:03 PM
UserB PC 11 logon 20/07/2010 3:35:00 PM
UserB PC 11 logoff 20/07/2010 3:35:03 PM

Required Format

Username Computer Date LogonTime LogoffTime
UserA PC 11 20/07/2010 1:41:01 PM 1:41:03 PM
UserB PC 11 20/07/2010 3:35:00 PM 3:35:03 PM

Thanks in advance!
James

[pike]

Hi brem
welcome to the forum but...This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.