Why do they make searching so hard..... Table Help Please

[zendog1960]

So frustrating. I get on google and search for the following: "Can I convert an excel table from horizontal to vertical?". I get results telling me how I can 'turn your tables vertically in 3 easy steps' and other such nonsense when in fact they are just talking about data that is arranged to LOOK like a table and data that has been created into a table. So I will ask you guys as you have yet to fail me with all that you know.

If I have taken data, with headers, selected it, them went to the insert tab and selected 'Table', can that newly created table be rotated so the headers are along the left side and all data is on the right? Basically rotate a table 90 degrees? LOL

I don't mean to be snide(ish) just really frustrated with how much time is wasted reading through post after post NOT answering my question..... LOL

Thanks Folks..should have come here first I know...my bad....

 

[Peter_SSs]

If I have taken data, with headers, selected it, them went to the insert tab and selected 'Table', can that newly created table be rotated so the headers are along the left side and all data is on the right?

If you want the result to also be a formal Excel table (ListObject) .. No

 

[zendog1960]

If you want the result to also be a formal Excel table (ListObject) .. No

Ok thanks. I think that just makes setting up this this crazy thing I want to try a whole lot harder. But I over think things too much too. ugggg.

Thanks Peter_SSs