# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

how do Iink a column from workbook 1 to workbook 2, but, the column I want to link from workbook 1 is in row 1 - 10 but in workbook two the column is linked but is staggered, i.e. row 1, 3, 5 then row 12, 14, 16, then row 23, 25, 27, then row 34
Solved by C. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/07/2018 - 04:46
Hello
Excelchat Expert 10/07/2018 - 04:46
How are you?
User 10/07/2018 - 04:46
good, how are you?
Excelchat Expert 10/07/2018 - 04:46
I am great, thank you!
Excelchat Expert 10/07/2018 - 04:46
So can you please elaborate more on the problem?
User 10/07/2018 - 04:49
I have a column in worksheet 1 that I want to link to worksheet 2 (same workbook). Column in worksheet 1 is Column A, row 1-10 (say numbers 1-10). I want this linked to worksheet 2, but in worksheet 2, those 10 numbers would be in column 1, but in rows 1,3,5 (1,2,3), then skip a bunch of cells and rows 10, 12, 14 (4,5,6), then rows 21, 23, 25 (7,8,9) and last row 32 (10).
Excelchat Expert 10/07/2018 - 04:50
Ok
Excelchat Expert 10/07/2018 - 04:51
Let me create a sample data and show you.
Excelchat Expert 10/07/2018 - 04:51
since we are skipping few rows in between in Sheet 2 - we have to manually put the formula for each cell.
Excelchat Expert 10/07/2018 - 04:52
so let's say Column A is on the sheet 1 contains number from 1 to 10
Excelchat Expert 10/07/2018 - 04:52
Please see the Preview on the right.
Excelchat Expert 10/07/2018 - 04:53
Are you with me on this?
User 10/07/2018 - 04:53
yes
Excelchat Expert 10/07/2018 - 04:53
Now let's go to Sheet 2
Excelchat Expert 10/07/2018 - 04:53
Please go to Sheet 2 on the preview.
User 10/07/2018 - 04:54
ok
Excelchat Expert 10/07/2018 - 04:54
Now suppose in Column A and row 2 I want to link 5th cell of Sheet 1
Excelchat Expert 10/07/2018 - 04:55
so for every cell we want to link we have to do it manually
Excelchat Expert 10/07/2018 - 04:55
is that what your are looking for?
User 10/07/2018 - 04:56
so there is no formula to account for spaces in between?
Excelchat Expert 10/07/2018 - 04:56
No
Excelchat Expert 10/07/2018 - 04:56
there is no formula possible in excel.
Excelchat Expert 10/07/2018 - 04:56
we can try few shortcuts depending on the data
Excelchat Expert 10/07/2018 - 04:57
For examples
User 10/07/2018 - 04:57
never mind, a colleague just told me how to do it - you should get some more training there. thank you
Excelchat Expert 10/07/2018 - 04:58
Ok but this is not possible on a empty sheet.
Excelchat Expert 10/07/2018 - 04:58
we need to see the data structure.
Excelchat Expert 10/07/2018 - 04:58
Which is I am telling you.
Excelchat Expert 10/07/2018 - 04:58
If you have data in other cells
Excelchat Expert 10/07/2018 - 04:58
Excelchat Expert 10/07/2018 - 04:58
and filter the result with blank cells
Excelchat Expert 10/07/2018 - 04:59
and then you will have all the blank cells together
Excelchat Expert 10/07/2018 - 04:59
and then you can just put the formula in 1 cell and drag it down.
Excelchat Expert 10/07/2018 - 05:00
Are you still there?
Excelchat Expert 10/07/2018 - 05:01
I presume your colleague has access to the data you have and he would have told you the same method.
Excelchat Expert 10/07/2018 - 05:01
so there is no direct way to do this on empty sheet.
Excelchat Expert 10/07/2018 - 05:03
Excelchat Expert 10/07/2018 - 05:04
Since you have been unresponsive, I request you to provide good feedback
Excelchat Expert 10/07/2018 - 05:04
Thank you

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.