# Sorting Problem in Pivot Table Column that contains both Number and Alphabets

1. ## Sorting Problem in Pivot Table Column that contains both Number and Alphabets

Greetings !!

Sorting Problem in Pivot Table Column that contains both Number and Alphabets

https://i.imgur.com/whkpnqh.png

In this file the survey number field contains both number and alphabets. When insert pivot table the ascending order of that column is not really ascending .. Please Help..

https://i.imgur.com/whkpnqh.png

Thanks

2. ## Re: Sorting Problem in Pivot Table Column that contains both Number and Alphabets

Excel sorts based on the first character of the string.
Which are your criteria for sorting ? The shortest string before the hyphen first ?

3. ## Re: Sorting Problem in Pivot Table Column that contains both Number and Alphabets

Sir,
The sorting criteria is like in J column

https://i.imgur.com/7BhT35U.jpg

like

1-1
1-1A
1-1B
1-2A

like

but as you see in pivot table column

53--
54-4
54-54
.
.
.

are in lower... it should come in first

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1