Why does my data take up multiple fields??

alex1fly · #1 06-30-2015, 01:59 PM

In this spreadsheet, some of my data sprawls across multiple columns. For example the date takes up columns A, B, and C. I think it was done this way for visual purposes, but I'm trying to crunch some numbers and this format does not work for me. Is there a way I can condense my data down into single columns each?

I want the date in column A only, the next number in column B only, and the address in column H only.

Please see attached file for an example. It is only a sample; the actual document is thousands of records, and editing the source is not an option.

Thanks in advance!

charlesdh · #2 06-30-2015, 04:40 PM

Hi,

The data you have is merged. Remove the "Merge" and you can the have the data in 1 column. However, you will need to "Expand" the columns to fit you data.

alex1fly · #3 07-01-2015, 08:28 AM

Quote:

Originally Posted by charlesdh

Hi,

The data you have is merged. Remove the "Merge" and you can the have the data in 1 column. However, you will need to "Expand" the columns to fit you data.

I was able to delete the merged columns separately from the columns that held the data and it worked! Thanks for the advice.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Text Fields in Form	robstark	Word	1	08-11-2014 11:26 AM
Project - variable data fields	pmarc	Word	7	04-04-2013 05:07 PM
Multiple identical fields	snorkerz	Word	4	06-25-2012 02:30 PM
'If... then... else' - output dependent on multiple fields	SiBrad	Mail Merge	3	01-13-2012 02:56 AM
Using fields to repeat data throughout a document	Brasada	Word	0	07-20-2010 02:37 PM