I'm using Excel 2010. Suppose you have this data in a spreadsheet:
line: content: 1 data 1 2 data 2 3 data 3 4 data 4 5 data 5
You made a mistake and now need to switch the values in the
content column (but not the
line column) between rows 2 and 4. It should now look like:
line: content: 1 data 1 2 data 4 3 data 3 4 data 2 5 data 5
How do I switch a column without changing the data in other columns?
To give another example, if I type
and then realize that I confused the small, sour citrus fruits, I want to select rows 2 and 4 (i.e., I want to select the entire rows),
and then automagically switch some but not all of the cells in those two rows.
Let’s assume that the column subset is constant; for example (as illustrated above), I would always want to leave columns A and B in place, and swap columns C, D, and E.
No matter what table it is, no matter what data is there, no matter data correlation. I need to select two rows (or columns), and swap them mutually.
- row1: abcdefg
- row2: hijklmn
Now after switching:
- row1: hijklmn
- row2: abcdefg