Special Scenario in Converting Rows to Columns

  • Thread starter Thread starter Loretta Jean
  • Start date Start date
L

Loretta Jean

Is there an easy way to convert the following:

Col A Col B Col C .....and so forth
Row 1 UserID Role1 Role 2 ....
Row 2 JeandL ABK098 CDKG3
Row 3 EdmonK DS0987 CK987

To this:
Col A Col B
Row 1 JeandL ABK098
Row 2 JeandL CDKG3
Row 3 EdmonK DS0987
Row 4 EdmonK CK987

The goal is to move each role (which are in multiple
columns) to one column for role, but to have the userid
repeated.

Transpose would require doing it line but line and this
file is really huge...

Thanks in advance for any help,
Loretta
 
Loretta Jean,

Probably the easiest way would be a small VBA routine. If the number of
columns of data is fixed and the same for each User ID, it should be fairly
easy.

You might want to provide a bit more detail and post your question in the
microsoft.public.excel.programming section. Someone might post some lines
of VBA for you.

Regards,
Kevin
 
Loretta
If you wish, send me a small file with a sample (20 rows or so) of what
you have. Take one row and show me what you want it to look like. I'll
work up some code to do what you want. Remove "hello" from my address.
Tell me the version of Excel and Windows you are using. HTH Otto
 
Thanks Kevin!

Kevin Stecyk said:
Loretta Jean,

Probably the easiest way would be a small VBA routine. If the number of
columns of data is fixed and the same for each User ID, it should be fairly
easy.

You might want to provide a bit more detail and post your question in the
microsoft.public.excel.programming section. Someone might post some lines
of VBA for you.

Regards,
Kevin
Click to expand...
 
Back
Top