• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

separating out data

brendaj

New Member
http://speedy.sh/Hc3AV/test123.xlsx


I am looking to separate out data provided on a spreadsheet. The location code is currently given in one column, but the data and date are both provided in the same column. Is there a way to separate out these two things? Most of the time there is a row space between the two types of data, but sometimes there is not. My ultimate goal is to have location, date, data all in separate rows w/o any unnecessary empty cells.
 
Brendaj


Firstly, Welcome to the Chandoo.org forums.


If this is going to be a one-off job, I would do the following


I would add 4 helper columns with formula to retrieve the data from the columns to the left (Yellow)

Then add a column to count the data (Orange)

Then copy/paste the helper columns as text

Then sort the data to get the count data = 3 (the 3 columns have values)


Refer your data with above comments here: https://www.dropbox.com/s/cx76hfs7ugpx7bw/test123.xlsx


If you are going to be doing that regularly I'd write a script in VBA, but probably tackle the problem from a different angle
 
Hi, brendaj!


Give a look at this file:

https://dl.dropbox.com/u/60558749/separating%20out%20data%20%28for%20brendaj%20at%20chandoo.org%29.xlsx


It uses too 4 helper columns.


Regards!
 
Back
Top