Hi all!
3 months ago I found a way to make one big list from multiple columns
example:
A B C
1 2 3
D E F
Into:
A
1
D
B
2
E
C
3
F
I would select my range, press a keyboard shortcut, choose the output starting cell and voila! But I can't find the method anymore. Everywhere I find OFFSET formulas or vba solutions.. I liked my manual method.. But I lost it
I'd greatly appreciate any hint!
Something like:
Please Login or Register to view this content.
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...
You mean to say you are trying to copy a rectangle range and paste into a verticle array ? without formula / vba,
☚ Click ★ just below left if it helps, Boo?ath?
Olly > Thanks for the efficient, ergonomic code! Although it's not what I was looking for (VBA-free), if I can't find the method I used to use I'll go with that.
Boopa > Indeed. And I'm sure it's possible because I have done it before ^^ as I described, I would press a ctrl+??? shortcut which would make a box appear. From there I selected input and output range, and with something like a checkbox, it'd tell Excel I wanted several columns into one
Olly > Thanks for the efficient, ergonomic code! Although it's not what I was looking for (VBA-free), if I can't find the method I used to use I'll go with that.
Boopa > Indeed; although it's not really a copy/paste. And I'm sure it's possible because I have done it before ^^ as I described, I would press a ctrl+??? shortcut which would make a box appear. From there I selected input and output range, and with something like a checkbox, it'd tell Excel I wanted several columns into one
This does sound like you had a VBA solution that could have been an "Add-on" that had a button. It could also have been a macro with a button assigned to it.Originally Posted by dourpil
Hi all!
I would select my range, press a keyboard shortcut, choose the output starting cell and voila! But I can't find the method anymore. Everywhere I find OFFSET formulas or vba solutions.. I liked my manual method.. But I lost it
!
Take a look in Excel Options, Add-ins and see if what you are looking for is listed in there but not active.
Last edited by newdoverman; 08-13-2014 at 10:39 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks