I have several worksheets with a single column of text data (about 20 rows) - I would like to rotate this data so that it now appears across the columns and in one row (and not down the column and in several rows) - how do I do this?
I would like to delete the original sheets afterwards.
thanks