Copy and Transpose Problem

**SimonDorfman** · 12-20-2011, 06:56 PM

Hello,

I need to find an automated way to transpose and copy some cells. This is probably easiest to explain with an illustration of the problem and the solution.

Problem:
Microsoft-Excel---copy-and-transpose-problem.jpg
Answer:
Microsoft-Excel---copy-and-transpose-answer.jpg

I've attached these examples as excel documents with some more data.

Many thanks in advance for any help or suggestions!

**NickyC** · 12-20-2011, 10:21 PM

Not quite a transposition issue, I think

If I’m reading your spreadsheet right, you want each of the values in columns C:S to be a separate entry under the heading “Image ID #1”, with the corresponding entry in column “SKU ID” equal to whatever is in column A for that cell’s row. If so, try this code (it will create two new columns of data starting in row 7 of your “problem” file)

Please Login or Register  to view this content.

**SimonDorfman** · 12-22-2011, 01:43 PM

Thanks so much, NickyC! Your code solved my problem perfectly.

Yes, maybe transpose isn't the right word, I don't know if there is a word to describe what your code does.