Copy and Transpose Repeating Data

**007fletch** · 08-27-2007, 01:56 PM

I'm certain this comes up a lot but I couldn't find a similar issue in the forums so I apologize if this duplicates someone's efforts.

I am relatively new to Excel but I am getting a baptism by fire. I have a spreadsheet that tracks equipment that is put on trucks. Column B contains all of the vehicle information in 10 cells (B1:B10)(B11:B20) This repeats 10 cells at a time for 6000 or so rows. I am trying to copy the information from the worksheet into another but transpose it into a series of rows (A1:J1)(A2:J2) etc.

Can someone help me with a macro or VB code that would automate this process? I am happy to offer semi-truck rides or time in really big tractors to anyone who can help.

Thanks in advance.

Andy

**mrice** · 08-27-2007, 02:10 PM

Try this. Button at top of first sheet.

**007fletch** · 08-27-2007, 04:51 PM

If you are ever in SW Wyoming... not far from Salt Lake actually, let me know and you can drive our trucks and tractors all over the darn place. Thank you so very much!

Andy