Hi all.
I have an imported text file with an ID number in column A. There are many rows with the same value in colum A. However, all the rows have different values in columns B to E.
Here's an example:
Col A - Col B - Col C - Col D - Col E
1001 - 8196 - Type A - 06/12 - 26/05
1001 - 4296 - Type B - 21/08 - 26/10
1001 - 4298 - Type C - 21/08 - 26/10
1002 - 3050 - Type B - 01/04 - 07/04
1002 - 3052 - Type D - 01/04 - 07/04
I need all the data for "1001" in the same row. So as opposed to having three rows for "1001", I only have one with all the data from those rows moved to the one row. Then the same for "1002" and so on.
Is this possible? Maybe with a bit of VB???
Please HELP!
I have an imported text file with an ID number in column A. There are many rows with the same value in colum A. However, all the rows have different values in columns B to E.
Here's an example:
Col A - Col B - Col C - Col D - Col E
1001 - 8196 - Type A - 06/12 - 26/05
1001 - 4296 - Type B - 21/08 - 26/10
1001 - 4298 - Type C - 21/08 - 26/10
1002 - 3050 - Type B - 01/04 - 07/04
1002 - 3052 - Type D - 01/04 - 07/04
I need all the data for "1001" in the same row. So as opposed to having three rows for "1001", I only have one with all the data from those rows moved to the one row. Then the same for "1002" and so on.
Is this possible? Maybe with a bit of VB???
Please HELP!