More Group Sites
Education Books
School Rankings
Jobless Net
Better Home
Welcome Guest! To enable all features please Login or Register.



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

Rank: Administration


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

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;

a binary with bits:
1	0	1	0	1	0	1	0	1	0	1	0

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

Results after sorting the rows in Descending order:
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, 18 February 2017 12:56:14 PM(UTC)  | Reason: Not specified

Rss Feed  Atom Feed
Users browsing this topic
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.