[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.
Bookmarks