#1
|
|||
|
|||
trying to compress 3 lines into one
i copied the data off of a website and the formatted it so that each different type of data ended up if a different column. (name, address, ect.) now i want to take that data and compress it all down to one line but there are 2 problems 1st all of the empty spots actually have a formula in them (ex: =a1), also one spot has #VALUE! and i need to get rid off all of them and the second is that one of the columns (name) might have more than one row filled up and i need both names (or to at least know that there are more names) img attached |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word 2013 - Compress pictures | charleswpj | Drawing and Graphics | 1 | 11-08-2015 12:36 AM |
Deleting grid lines but keeping the axis lines | CoffeeNut | Excel | 0 | 04-01-2013 01:50 PM |
How can I compress slide shows under Apple? | Cliff | PowerPoint | 0 | 01-10-2012 12:04 PM |
Compress Emails as Attachment | SJT | Outlook | 2 | 11-30-2011 01:36 PM |
Getting blank lines instead of supressed lines. | Welshie82 | Mail Merge | 2 | 11-14-2011 01:41 AM |