Hello,
Looking for help on how to transpose data in columns (grouped by header) to rows. Column range is A:P. I receive a csv file with leads that looks like this:
ID 01Name 01Title 01URL 01Number 01Comp 02Name 02Title 02URL 02Number 02Comp
123 Joe Smith CEO joe.com 555-1212 joeinc Ed Jones SVP joe.com 556-1212 joeinc
Each contact is on the same row grouped by number (01, 02, 03 up to 05). I would like to convert it to the example below grouped by the unique ID:
ID Name Title URL Number Comp
123 Joe Smith CEO joe.com 555-1212 joeinc
123 Ed Jones SVP joe.com 556-1212 joeinc
I'm using Excel 2010.
Best Regards,
IB
Looking for help on how to transpose data in columns (grouped by header) to rows. Column range is A:P. I receive a csv file with leads that looks like this:
ID 01Name 01Title 01URL 01Number 01Comp 02Name 02Title 02URL 02Number 02Comp
123 Joe Smith CEO joe.com 555-1212 joeinc Ed Jones SVP joe.com 556-1212 joeinc
Each contact is on the same row grouped by number (01, 02, 03 up to 05). I would like to convert it to the example below grouped by the unique ID:
ID Name Title URL Number Comp
123 Joe Smith CEO joe.com 555-1212 joeinc
123 Ed Jones SVP joe.com 556-1212 joeinc
I'm using Excel 2010.
Best Regards,
IB