Transpose in Excel

Robm1955

I know how to use transpose, but this is a little different. I have copied a list of beers, and their types, and tastes, etc from a table on a website. I pasted this into Excel, and obviously, it created one long column. The first 9 cells are the headings, so I first transposed those into a row. What I have been doing is, selecting the next 9 cells, and transposing those into a row underneath, but it's taking ages. Knowing that there are 9 columns of information, is there a way of selecting the whole column of data, and transposing it into rows of 9 columns? Hope I have made this clear.

tizerbelle

Can't help directly with the transpose - what I do is copy the table from the website and paste it into word and then copy from word to excel - that normally keeps the table layout

p00hsticks

I agree with RobM - try first pasting it into Word, and if necessary use the 'convert text to table' function

https://support.office.com/en-us/article/Convert-text-to-a-table-or-vice-versa-b5ce45db-52d5-4fe3-8e9c-e04b62f189e1

You should then be able to past from Word into Excel and retain the columns

Robm1955

Thanks for that guys. I've used text to table before but never thought of that method seeing as the text was in one long column, but it worked. Did have one problem though, when I discovered some of the data was in the wrong column. Going through the list on the website, I found that two of the rows did not have 9 categories filled in, so this threw the rest of the table out. Soon sorted though, by add #### to the blank spaces, before converting to table. Everything's good now. Thanks again. That saved some work.

paddyrg

I'm not quite sure I understand the question, transpose can transpose whole tables/blocks so I am not sure why you'd do it a column at a time?

Oops, posts crossed, glad you're sorted

cookie365

This is the sort of thing that ASAP makes easy
http://www.asap-utilities.com/index.php