# Collating data from separate columns

#### Milano1000

##### New Member
Hello all, I am confused how to collate or tabulate the results in this data set. Any help would be appreciated. I think this can be accomplished by using a formula but every effort has failed. I have given up and am asking for help.

This is it is just a set of math mathematical formulas that represent data points for a roll playing game. There 3 columns, Range Band (column B), Damage (column C), and Penetration (column D). The columns C and D are two separate formulas drawn from mathematical formulas. What I am trying to accomplish is take the data set of B:3 to D:31 and have Excel automatically Create the table in cells F:20 to K:21. Could I get help doing this from you all?

To clarify or reiterate, Damage gets smaller with Range, as does the Penetration. I am looking for a way to tabulate the data in table B:3 to D:31. Then reproduce it in F:20 to K:21. I highlighted the applicable data in red (column B) and Orange (column C and D). For example, (in row 7) at 145m the data should be eventually read as "4 / 2". As in a reference to G:20 and G:21. At 900m (row 27) should eventually read "1 / nil" as in K:20 and K:21.

I hope what I am asking makes sense. If not please do not hesitate to ask me and I will try to reiterate what I am trying to do.

Formula results.xlsx
ABCDEFGHIJKL
1
2BandDamagePenetration
30
4052
5542
61042
714542
815042
915542
1016042
1116542
1217032
1317532
1422532
1525032
1627532
1730033
1832533
1935033
20375230 - 55 - 165165 - 275275 - 350350 - 575575 - 950
21400235 / 24 / 23 / 23 / nil2 / nil1 / nil
2252524
2355024
2457524
2560015
2662515
27900112
28925113
29950015
30975016
311000018
32
Sheet1

#### Milano1000

##### New Member
Hey thank you all! Peter_SSs I worked off your suggestion and it came out perfectly. My actual file is 11 tabs long. Mostly for organization because of the amount of data and cross referencing, so it took me these last few days to translate your solution into the actual data.

To Doss, I appreciate the help as well. It could be an easier or better solution but given that this is just a hobby and something I do in free time I didn't really want to learn VBA.

To RandomHelper, I didn't see your posting until after I was engaged with the idea from Peter. It could be that this is easier also.

Thank you again guys.

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

#### Peter_SSs

##### MrExcel MVP, Moderator
You're welcome. Glad we were able to help. Thanks for the follow-up.

Replies
6
Views
107
Replies
1
Views
187
Replies
0
Views
157
Replies
3
Views
83
Replies
6
Views
78

1,129,680
Messages
5,637,745
Members
416,982
Latest member
lisam77

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back