Home
Join

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

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...