Is there a way to select the text within the cell instead of the standart A1, B1?

What I am trying to achieve is the following
I have a list which has a names defined e.g. specialfeatures12185278031
When I put = in front of it and drag it down I get the list
Transpose0.PNG

Now I would like to have the list instead of down to output across. Which is done with =Transpose(E2), however, transpose doesn't output the text when I select the cell.
Transpose3.PNG

When I type in the source manually with =Transpose(specialfeatures12185278031) it outputs exactly what I need
Transpose1.PNG

What I need is a way to select the cell with =Transpose but instead of the cell number it would give the text within the cell. I have tried =Transpose(CELL("content", E2)) doesn't help at all.

All help is highly appreciated!

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

you can use INDEX, e.g.

D2: =INDEX(specialfeatures12185278031,COLUMNS($D2:D2))
copy to the right

note: change , to ; pending locale requirements

edit: not sure the above is actually answering your question, but not sure what the question is -- you might want to look at INDIRECT if you're trying to leverage values in C to generate D onwards, e.g.:

D2: =INDEX(INDIRECT(REPLACE($C2,1,1,"")),COLUMNS($D2:D2))
copy to the right