Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
As a less-than-subtle disclaimer, I am a newcomer to VBA programming, and I apologize for not having had the time to look into my (fairly pressing) problem much on my own before casting this general inquiry to the forum: Does anyone know of a macro that would allow me to iteratively transpose series of cells in one column as based unique values in another column? As an example, I need to get from this: A B 1 17 1 90 1 96 1 6 2 12 2 10 to this: A B C D E 1 17 90 96 6 2 12 10 where column A contains the unique values by which values in column B are transposed. (My spreadsheet contains thousands of rows. There would be enough columns for the transpositions, however, because no more than 256 instances occur for any given value in column A.) In lieu of an extant macro that would do this, I would, of course, be interested to know if anyone could help me determine what other code I might attempt to patch together toward this end. Any help or ideas on this would, of course, be most appreciated! Aaron J. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I number rows based on unique values in another column? | Excel Worksheet Functions | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Total cells of one column based on the values in another column? | New Users to Excel | |||
Count unique values in 1 column where cells in another show non-bl | Excel Discussion (Misc queries) | |||
Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions |