Transpose Columns To Rows (with Variable Columns)

**G.HendriX** · 06-26-2011, 12:13 PM

Hi All
I've a pretty challenging work to do, I am trying to use the TRANSPOSE funcion to transpose rows/columns, till now, with no luck.

Because the required columns to output are not fixed, this approach doesn't get the point...

Please, see the attached file for an example:

EXAMPLE.xls

Example.jpg

Any suggestion will be very very well accepted...

**JBeaucaire** · 06-26-2011, 06:30 PM

Based on you removing the blank row at the top so your table sits at A1, and remove all the other stuff except the data... try this:

Please Login or Register  to view this content.

The macro operates on the assumption that the 1-3 matching rows per code will be together in the list, as shown in your example.

**Excel Eejit** · 07-07-2011, 05:26 PM

Hi

Your solution is really good but can it be modified if you have data with more than 3 rows per code. I have a similar problem but my data contains up to 40 rows per code and 5000 codes.

Thanks
EE

**JBeaucaire** · 07-07-2011, 06:19 PM

Sounds horrific. A more complete sample data set / example results would probably be in order.

**Excel Eejit** · 07-08-2011, 02:50 PM

Hi

Please find attached a sample of my data and how I need it arranged. My end goal is that I have one cell of notes per member.

I have tried to use pivot tables and IF functions but I don't know enough about excel to do what I need.

Any help would be great.

Thanks

**JBeaucaire** · 07-08-2011, 04:57 PM

Is the data really already sorted that way? And it would be better to just put all the "strings" for a single case into a single cell, yes? Try this...

**Excel Eejit** · 07-08-2011, 06:19 PM

Thank you thank you thank you - you are a god!!

**JBeaucaire** · 07-08-2011, 08:40 PM

You should use the F8 key in the VBeditor to step through that code one line at a time and see what it's doing on the sheet. Everything I did I did mostly with standard formulas, then just pasted the results to a new sheet.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.