I have a list of numbers I want to display horizontally instead of vertically. Is there a simple way to do this other than retyping each number?
My worksheet is attached. Thanks!
I have a list of numbers I want to display horizontally instead of vertically. Is there a simple way to do this other than retyping each number?
My worksheet is attached. Thanks!
Copy > Paste Special > Transpose
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
In C3
=SMALL($A$3:$A$213,COLUMNS($A$3:A3))
and drag it the right
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks