Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Excel - Split one LONG column into two smaller columns

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
chris pike
Asked:
chris pike
  • 4
  • 2
1 Solution
 
Roy CoxGroup Finance ManagerCommented:
There's no data in the Remote workbook and very little in the other one.
0
 
chris pikeAuthor Commented:
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
 
Roy CoxGroup Finance ManagerCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
chris pikeAuthor Commented:
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
 
Ejgil HedegaardCommented:
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
 
chris pikeAuthor Commented:
THanks Ejgil.
Always appreciate your help/
Chris
0
 
chris pikeAuthor Commented:
Thanks for your help.
Always find a way to make it work.
Cheers
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now