View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
autoguy autoguy is offline
external usenet poster
 
Posts: 5
Default 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