Excel 2007 : How to Make Two Columns into Two Rows?

**Gnokrojam** · 03-01-2012, 03:54 PM

I want to start with a table, as shown, and essentially transpose the first and last columns of data into a modified table. I'd really rather not use a macro.

This is part of an effort to start with a form and fill in the details for a specific lab test. The original table gets created as part of the lab test preparation. I want to use this information as part of a graph. The text in the first column will become a row of column headings. The last column of values will become the value under the column heading. These values will get dragged down to create horizontal lines in the graph. The actual original table is much larger. Actually doint a Paste Special - Transpose will require editing that may mess up other areas in the form. Columns A and B will be other data in the form.

I don't know how to do macros.

Thank you.
Phil

**dilipandey** · 03-01-2012, 04:02 PM

Hi Phil,

Try looking at Transpose function and array functionality using which you can achieve the desired results, if you face any issues - post an sample file not image. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Gnokrojam** · 03-01-2012, 06:16 PM

Thank you, DILIPandey!
Those hints were what I needed. I did some reading and learned about ARRAY equations. Using the Transpose function in an array equation gives me just what I was after.
Thank you.
(It must be 3:30 AM there. Now that you have helped me please feel free to get some sleep.)
Phil
Wisconsin