Transposing and insertion of rows into a column

You could use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Dear Antonio,

That is nothing short of genius!! I cannot thank you enough for that.

Will that work regardless of how many columns have text in them (sometimes there are 8 or 10 languages that we need to get into just the one column) or will I have to adjust something in the macro?

Again, thanks very much!

Jim

Dear Antonio,

The client has altered its requirements, and your wonderful macro would need a small additional function.

Each time the macro transposes and inserts the row into column A would it be possible to insert the column headers (so the text in row 1) above the corresponding transposed cells? So as an example, B4 is transposed under A4 with a space inbetween (your macro already does this), and then the column header B1 is also copied between A4 and A6 (which contains the texts from the transposed B4), with an empty row above and below it? It would do the same for the transposed cells from C4, D4, etc., always copying down the corresponding column header.

Does that make any sense? I'll attach a couple of before and after excels files again in a moment.

Best regards
Jim

Here are new attachments.

Hi Jim, try it

Please Login or Register  to view this content.

Hi Nilem,

Wow, that works pretty well! Many, many thanks! As a final tweak that would absolutely perfect it, is there any way of keeping the formating (i.e. bold) of the column headers when they're copied down?

Jim

try

Please Login or Register  to view this content.

That's absolutely great! Many, many thanks for your help on this one. Greetings to Russia from Salzburg, Austria!

Jim

---------- Post added at 03:03 PM ---------- Previous post was at 03:02 PM ----------

That's absolutely great! Many, many thanks for your help on this one. Greetings to Russia from Salzburg, Austria!

Jim

@ thomsonjim

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Thank you, Cutter, for these tips. I couldn't work out how to mark it as solved.

Hi Nilem,

I'm getting a "Run-time error 9" when I try to run your macro on the attached Excel doc (which is how the files will generally look before we perform the macro). When I debug it hightlights the following line: k = k + 2: y(k, 1) = x(1, j)

Any ideas what might be wrong here?

Jim