The basic rows to columns fix won't work

[lilinker]

Hi there. Hoping anyone can help. Below is a screenshot of data. I need to move the first 6 rows of data into one row, many columns and then be able to repeat this function for the remainder of data within my spreadsheet OR hopefully arrive at a solution where I will NOT actually have to repeat this function several hundred times.
I found some tutorials for transposing columns to rows and that did work, but I noticed when I started to perform the function again and again in my workbook that previously transposed data was apparently overwritten when I performed the next transpose function. I'm not sure why.
Does anyone think they can help? THANKS!!!!

 

[hiker95]

lilinker,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense.

And, we can not tell where your raw data is located, cells, rows, columns, and, we can not tell where the results should be, cells, rows, columns.


Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
http://www.mrexcel.com/htmlmaker.html

Or, when using Internet Explorer, just put borders around your data in Excel and copy those cells into your post.
See reply #2 the BLUE text in the following link:
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045