Multiple rows to just one column loop

[etuckram]

[FONT=Courier New]Hi Everyone,

I'm trying to figure this one but I'm unable to. I need your expertise.

I have 1 sheet that I want to extract to a new sheet.

let us say sheet1 contains 5 columns

Input
1 2 3 4 5
Date | Description | time in minutes | Category | Sub Category
01/01/2013 | Description1 | 60 | A | 1 |
01/01/2013 | Description2 | 60 | B | 2 |
01/01/2013 | Description3 | 60 | A | 1 |
01/02/2013 | Description4 | 60 | B | 2 |
01/02/2013 | Description5 | 60 | A | 1 |
01/02/2013 | Description6 | 60 | B | 2 |

Output
1 2 3 4 5 6 7
Date | Description | time in minutes | Description | time in minutes | Description | time in minutes |
01/01/2013 |Description 1| 1 | Description 2| 1 |Description 3| 1 |
01/02/2013 |Description 1| 1 | Description 2| 1 |Description 3| 1 |

My goal is to collate all data from rows in column. So if I have 10 entries for 01/01/2013, It will be copied to 20 columns in a single row that is for that date.

Thank you!

Hoping for your speedy response.

[HSV]

This must do the trick for you.
It is not my own code, but I've adapted to your wishes.

Please Login or Register  to view this content.