Solved

Excel - Split one LONG column into two smaller columns

Posted on 2016-07-14
7
76 Views
Last Modified: 2016-07-27
Hi Experts,
I have a workbook that has a table with a long list of names.
I want to copy the list of names and split it into two columns so it is easy to print.

I also have a small list that I also want to copy into the same remote sheet without splitting.

I would love it if it was easy to change the size of the range if names are added, or if columns change later on.
Thanks so much

Have a look.
Image helperSource.xlsx
Remote.xlsx
0
Comment
Question by:chris pike
  • 4
  • 2
7 Comments
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41713062
There's no data in the Remote workbook and very little in the other one.
0
 

Author Comment

by:chris pike
ID: 41713089
They are dummy sheets, on the data sheet you will have 40ish cells of names

I want to split it into two columns on the remote sheet in those exact locations

I hope that helps
Thanks
0
 
LVL 18

Expert Comment

by:Roy_Cox
ID: 41713108
There's only 10 names in the example.

I can't see what exact locations you mean.

When you post example workbooks make sure that you demonstrate the source data and the required result exactly, that will help provide an accurate answer.

Do you want a VBA solution?
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

Author Comment

by:chris pike
ID: 41713203
OK , great I will do that next time for sure.  Thanks

Formula would be great if it is possible, I never have any success with modifying VBA if I have to add of change a row or anything.
Formulas sometimes are a bit easier I think.

I am lost with VBA.
Thanks so much
Chris
0
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 41714809
Here is a solution with formulas.
Names in 2 tables in source workbook.
I duplicated the names to show the result.
Table1 split at position 46, with values up to 60 if exist.
Table2 start in position 61 as shown in picture.
Save both workbooks in same folder, then Excel will make the links work.
Source.xlsx
Remote.xlsx
0
 

Author Comment

by:chris pike
ID: 41731180
THanks Ejgil.
Always appreciate your help/
Chris
0
 

Author Closing Comment

by:chris pike
ID: 41731183
Thanks for your help.
Always find a way to make it work.
Cheers
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question