Copying rows to columns

Ok, then we need to start over again.  How do I do it?  I am using an older worksheet that some one gave me, where someone before me figured out how to do it but he doesn't work here anymore.  I have tried to recreate what he did but it doesn't work, there are no formulas other than just "=" to the cell where the information is located at.  The only way I see that it worked is if he linked each cell one at a time, manually.

Unfortunately, the TRANSPOSE function does not work with merged cells (one of the many reason to avoid using merged cells).

OK, switching gears I figured out my last question but it created a new problem.

I am trying to use this feature/function in an existing workbook and the cells that I am using the "Transpose" in are marched cells.  So when I try and it, I get an error... something like I cannot use an array over merged cells.  When I undo the merged cells, it works but I am unable to remerge the cells.

Any suggestions?

Try using PowerQuery and the Transpose function in it.

You can add new rows to bottom of blue table or change data values.

Right click on green, transposed table, and select Refresh to pull new data through to the transposed table.

In my example both tables are on same tab, but you can put the output on separate tab (that is actually default action).

You can look at this example in my online example file

https://1drv.ms/x/s!Am8lVyUzjKfpowARghSdfg1koqJf?e=H0lKb5

Link to this workbook. Look for the Tab with your ID on it

Transpose- Power Query Helps In Transposing Data       2019 03 01

https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an example with the picture is given below. Transposing Data By Power Query Let’s go through the steps in detail for transposing data. Step 1: Open the data in Power Query Open the data...

.

Transpose Using Power Queryhttps://www.myexcelonline.com/blog/transpose-using-power-query-excel/****Power Query lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to transpose data very easily. Transposing a data table is basically rotating your data from rows to columns, or from columns to rows. To further explain this concept, screenshots are provided below.

.

What exactly do you want the result to be?