LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
clk clk is offline
external usenet poster
 
Posts: 17
Default Combining Two Columns of Data

Hello. I have a spreadsheet with data in column A and column H. I
need to "copy and paste" all data from column A (starting in A3) to
Column N (starting at N3). Once that is done, I move over to column H
(starting in H3) and copy all of the data there to Column N under
where the data stopped from column A.

I hope this make sense but here is a little example of what I want to
do:

A H N
1 7 1
2 8 2
3 9 3
7
8
9


I thought an "If" formula would work but I am not getting it to work
right.

Any help would be appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
combining two columns of data DwwPRO Excel Discussion (Misc queries) 3 June 25th 07 07:59 PM
Combining data from two columns CLR Excel Discussion (Misc queries) 10 August 9th 06 09:21 PM
Combining data from two columns PCLIVE Excel Discussion (Misc queries) 0 August 2nd 06 08:10 PM
combining 2 columns of data Miss Dedly Excel Discussion (Misc queries) 1 January 12th 06 07:14 PM
Combining Data from Multiple Columns JT Excel Worksheet Functions 2 January 8th 06 07:39 PM


All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"