Transpose (switch) rows into rows. and columns into comuns.

Hi and welcome to the forum

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

If you are comfortable with VBA, I have found a macro that may work for you.
Source: http://www.extendoffice.com/document...ip-column.html

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

vtikhon...
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

@ _rapier_ I asked you already to NOT upload pictures!!

Also, please do not use file-hosting site for your file, rather upload them here...
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

@Rapier

Please Login or Register  to view this content.

Not for me, but that not the point.

You want to get help from forummembers, and you are asked to add an excel file (instead of an PNG, in which we can't work).

You need the solution very quick (urgent) and still you don't feel the need to post the file.

It is of course your choise, but why you think forummembers will help you if you don't add what's been asked for your help?

Take this in mind:

Would you help someone, who won't give you the information you need to help him / her?

ok sorry
i was just in hurry to go sleep and wanted to find in the morning 'surprice' by solved this issue

here are files
excel correct.pngexcell wrong.png


// i dont know why pics are not in attached files. it is lilttle complicated here.. and something like 'insert line' is messing it all.

btw i dont know what is macro or visual basic something. i would appreciate step by step attittude to me. ty v much

@Rapier,

your title to the problem is:

Transpose (switch) rows into rows. and columns into comuns.

If I see your excel file you want to count the numbers of words in a cell.

This is a whole differant question.

no
i dont want count nothing. (it was example of data. EXAMPLE of corelation)

i was writing text like here now - into horizontal line = row. like abcdefg....
three lines, one under other one would look like:

abcdefg
hijklm
nopqrstuvwxyz

(english alphabet in correct order in three lines)

but if i make mistake and write it like this:
abcdefg
nopqrstuvwxyz
hijklm

then i must swap second and third line each other.


why is that so hard for you to understand?!



&
same situation can occur, when i would be writing it in vertical. > into columns
like:

a e o
b i p
c j q
d k q
e l s
f m t
g n u

SOLVED by this elegant step by step guide. awesome. systematic, stepbystep, displayed instructions how to do it:

Please Login or Register  to view this content.

BUT i dont know three things:
1, how to save that macro in my excel to be there forever prepared for use.
2, how to make button in excel to run that macro by one click.
3, how modify it, to not swap WHOLE rows, columnsm; but just few celles selected from it !

ty guys