Transpose problem: produces zero results

vintage36

Board Regular
Joined
Nov 29, 2011
Messages
56
I hope this is not too trite for the forum.:confused:
I have 16 numbers in a vertical list, which I want to convert to horizontal.
I am using Control+C, selecting an empty cell then using Paste Special, ticking Transpose, then OK.
instead of the expected horizontal list of numbers, all that appears is a list of 0s.
I do not understand why and so need help; please.

FWIW I am using a legacy version of Excel.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,210
Office Version
2019
Platform
Windows
Is it possible that the 16 numbers are the result of a formula and not hard coded?
 

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,210
Office Version
2019
Platform
Windows
I found a solution by selecting Values and Number Formats.
is that the best way?
Seems reasonable if it works for you and you get your expected results. The only alternative that I can conjure up is to use Power Query. If you are interested in that, please post back.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,473
Messages
5,414,747
Members
403,543
Latest member
Phx007

This Week's Hot Topics

Top