| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose data using Vba
Hi,
I have the following data that needs to be on the same row Part Number Aml Part ABC123456 XY123456 ABC123456 XY324567 ABC123456 JKT67893 GBC123456 HFYRUTR FBC123456 JGHTYRE FBC123456 LK456789 FBC123456 LGJTUR45 CCHF7899 LIE475869540403 Result would be Part Number Aml Part ABC123456 XY123456, XY324567, JKT67893 GBC123456 HFYRUTR FBC123456 JGHTYRE, LK456789, LGJTUR45 CCHF7899 LIE475869540403 There will be 1000's of records, a Part Number can have any number of Aml Parts I do have code I wrote that works but it is very slow Any help greatly appreciated Rgds Raymond Allan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose data and retain links to original data | Excel Worksheet Functions | |||
| transpose data | Excel Worksheet Functions | |||
| transpose data | Excel Discussion (Misc queries) | |||
| Transpose data | Excel Programming | |||
| transpose data | Excel Worksheet Functions | |||
Threaded Mode
