More Group Sites
Education Books
School Rankings
Jobless Net
Better Home
Enviro++
更好教育论坛


Help | Subscribe/Unsubscribe | Rules | Other Group Sites: Better Education | Better Education Forum
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Share
Options
View
Go to last post Go to first unread
hong  
#1 Posted : Saturday, February 18, 2017 12:46:04 PM(UTC)
hong

Rank: Administration

Reputation:

Groups: AcademicCoachingSchool, admin, Administration, BookSeller, CatholicSchool, CoachingAdult, CoachingProfessional, CoachingSports, ExtraCurriculumCoaching, IndependentSchool, Moderator, MusicTeacher, PrivateSchool, PublicSchool, SelectiveSchool, tutor
Joined: 11/23/2008(UTC)
Posts: 521

How to flip Excel columns

In applications you may need reverse order of a string or a number, such as the conversion between Big Endians and Little Endians, there are several ways:
1. use VBA script: Flip Contents in an Excel cell (Text or a Number)
2. use C# or other programming languages: Concatenate two integers into hex with specified lengths with leading zeros

Another way to use Sort rows from left to right in Excel:
1. Data > Text to column, split a string or a number into columns;
2. Add a row with an Ascending order from 0 to the number of total columns;
3. Select all the rows to sort, no header and no expansion. Data > Sort, click option, select Orientation > Sort from left to right;
4. Sort the rows in Descending order;

Example:
a binary with bits:
Code:
1	0	1	0	1	0	1	0	1	0	1	0

add a row in Ascending order:
Code:
0	1	2	3	4	5	6	7	8	9	10	11


Results after sorting the rows in Descending order:
Code:
11	10	9	8	7	6	5	4	3	2	1	0
0	1	0	1	0	1	0	1	0	1	0	1

Edited by user Saturday, February 18, 2017 12:56:14 PM(UTC)  | Reason: Not specified

Sponsor
Rss Feed  Atom Feed
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.