Home
Join

MS Excel stack all columns in one

Posted by greg28818
Needs answer
Microsoft Office
I want to stack all the columns under A in excel.  Anyone have solution?  I've looked at concat and  merge and don't seem to work for me.
attach_file Attachment DAS_2022.csv 42.4 KB
Spice (9) Reply (8)
greg28818

Traditional, Headless or Hybrid CMS: Which Is Best

2022-08-17 18:00:00 UTC Webinar Webinar: Traditional, Headless or Hybrid CMS: Which Is Best Event Details View all events

8 Replies

  • Excel does not have a way of using a formula to move cells around.  You would need to use VBA to do this.  Given that you really don't have that much data to manipulate, relative to what you are trying to do (unless this is one spreadsheet out of many that you must handle), then you would probably be best off just selecting all cells in volumn B, cutting them, and pasting them at the bottom of column A.  And then repeating, with columns C, D, E, and so on.

    If you do handle this data in many sheets, is there a way of adjusting the source of the data so that it puts it all in one column to begin with?

    Spice (1) flagReport
    Was this post helpful? thumb_up thumb_down

  • Well... do you mean programmatically or using cut and paste?  Seeing that it's only 14 columns...  if I needed to "manually" rearrange data as a one time thing, then I might consider using the following keys: SHIFT, CTRL, the cursor (arrow) keys, X and V...

    Go to cell B1, SHIFT + CTRL + down arrow to highlight, CTRL - X to cut, go to A1 and CTRL-down to jump to the bottom, down arrow once to the open cell and CTRL-V to paste.  Then cursor over to Col C (right arrow a couple of times), CTRL-up a few times to get to C1, repeat...  

    Spice (1) flagReport
    Was this post helpful? thumb_up thumb_down

  • Gah, there is a way I have done it once before and cannot for the life of me find the spreadsheet with the code. :(

    Was this post helpful? thumb_up thumb_down

  • It would be a few sheets couple times a year.  It's actually the UPS DAS zip code list and appears to only come in excel with a bunch of formatting in it.  Which I exported that to a csv to get the attached file that I want to stack the columns.  I could write some code to do it but wanted to see if there was an easier way.   

    Was this post helpful? thumb_up thumb_down

  • BTW, Rich7359​ Thanks for the shortcut suggestions.  Shift + Ctrl + down arrow works nice.

    Was this post helpful? thumb_up thumb_down

  • You might be able to use the consolidate tool from the Data tab.

    Was this post helpful? thumb_up thumb_down

  • what do you mean by stack?

    I see unique entries, nothing to match and stack similar etc.

    Was this post helpful? thumb_up thumb_down

  • Combine all the columns into one column.

    Was this post helpful? thumb_up thumb_down

or sign up to reply to this topic.

Didn't find what you were looking for? Search the forums for similar questions or check out the Microsoft Office forum.

Read these next...

  • No Network Access

    No Network Access

    Networking

    Hello,Suddenly, my Windows 2012R server has NO network access through either of its two nic cards; it is a DELL PE T430. It is configured to get IP info from DHCP, and that works ok; both NICs can get an IP just fine, but after I get the IP address,  I am...

  • Understanding VPNs

    Understanding VPNs

    Security

    Hello I'm trying to learn the concept of VPN's and there's some aspect of VPN's I'm not sure about. When I configure a remote access VPN on a Fortigate, I configure the following client range 192.168.3.10-192.168.3.40When the client connects and I do a ro...

  • Snap! Outlook crashes, getting phished, supermoon, CyberOne, DALL·E 2 + SpiceRex

    Snap! Outlook crashes, getting phished, supermoon, CyberOne, DALL·E 2 + SpiceRex

    Spiceworks Originals

    Your daily dose of tech news, in brief. We made it to Friday! Before we consider our weekend plans, let's look back in time. While not the storage we're accustomed to, back on August 12, 1877 (although there appears to be some debate on the actual ...

  • Spark! Pro series – 12th August 2022

    Spark! Pro series – 12th August 2022

    Spiceworks Originals

    I want my… I want my…. Spark!    Just a reminder, if you are reading the Spark!, Spice it up. We like it spicy here! Today in History: The IBM PC Introduced August 12, 1981 IBM introduces its ...

  • Repeated Attacks on my Firewall - What to Do ??

    Repeated Attacks on my Firewall - What to Do ??

    Security

    I've got a UTM Firewall and I'm constantly getting notifications that someone is trying to gain access through an SSL-VPN. The attacking IP address is almost always different, so blocking the IP every time is not a sustainable solution. They haven't got t...