Convert multiple columns into rows with row and column titles

[nnklem]

Hello all,

I have a set of data that looks something like this. Way more rows and sometimes more columns, but you get the idea.

Before.jpg

I need to take each column of data and create a seperate row. Essentially, I'm trying to convert multiple columns of data into one column, but I need use the column label being converted as the row label if that makes sense. I need the final product to look like this:

After.jpg


is this possible? I have scoured the interwebs for a solution, but I don't think I'm asking the right questions. Please help.

[hoyasaxa215]

This will get you close. You may need to rearrange the columns. I assume your data starts in A1 and your output table starts in A6. Enter the 3 formulas in the 3 cells below and copy down.

In A6:

Please Login or Register  to view this content.

In B6:

Please Login or Register  to view this content.

In C6:

Please Login or Register  to view this content.

[nnklem]

I was directed to the below YouTube video from a user on another site that was very helpful. I am posting it here in case anybody else has my same issue.

https://www.youtube.com/watch?v=xmqTN0X-AgY