Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reformat data from rows to columns
In column A, I have a unique value. In column B, I have a series of
additional values which are keyed to match the unique value in column A. Here is an example of what I have: COLUMN A COLUMN B RDK3173BK 14542 , 14567 , 16763 WSK3173AK 14644 , 16688 , 16789 , 16821 PCK3MOP 14638 , 16637 , 16815 , 14639 , 16638 , 16816 I need to convert the series of values in Column B to individual rows that still match Column A. Like this: COLUMN A COLUMN B RDK3173BK 14542 RDK3173BK 14567 RDK3173BK 16763 WSK3173AK 14644 WSK3173AK 16688 WSK3173AK 16789 WSK3173AK 16821 PCK3MOP 14638 PCK3MOP 16637 PCK3MOP 16815 PCK3MOP 14639 PCK3MOP 16638 PCK3MOP 16816 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformat Data | Excel Programming | |||
reformat columns | Excel Discussion (Misc queries) | |||
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
reformat excel to letters in columns | Excel Discussion (Misc queries) | |||
reformat columns to rows? | Excel Worksheet Functions |