# Cosolidating data

#### Philip Rogers

##### New Member
I am trying to find a way to consolidate the data that is on three different worksheets. The column headings are the same BUT the information in Col A Row 1 to .... is different. The data in the columns to the right is determined by the name in col A.
Bowling.htm
ABCDEFGHIJKL
1Statistics
2Club:FennerCricketClub
3MatchType:EYCAPremierLeagueSeason:2005
4Player:All
5NameMOversMdnsRunsWktsAvgEcon.S/r5whBest%Total
6AHussain25130130.006.0030.0001-300.68%
7GPowley715270235.004.6745.0001-211.36%
8JLatus316354227.003.3848.0001-201.36%
9JMPark17190.3494564111.122.3927.8826-4927.89%
10JPSowter17103163571918.793.4732.5317-8812.93%
11LLaybourne126211221544.203.5674.4003-603.40%
12MArundell91425486.753.8610.5004-105.44%
13PFuller1477102681222.333.4838.5004-768.16%
14PScrowston1825481516.203.2430.0003-383.40%
15RBarker1058102021414.433.4824.8605-229.52%
16SHewitt19175.1444673413.742.6730.9113-1123.13%
17SLatus13.501142.752.875.7504-112.72%
2005 Bowling

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

#### Philip Rogers

##### New Member
Consolidating data

The information in Col B is in multiples of 6 i.e 10.3 = 10 + 3/6

#### Philip Rogers

##### New Member
Consolidating Data

Should read COL C not Col B

#### Philip Rogers

##### New Member
Bowling.htm
ABCDEFGHIJKL
5NameMOversMdnsRunsWktsAvgEcon.S/r5whBest% Total
6A Hussain25130130.006.0030.0001-300.68%
7G Powley715270235.004.6745.0001-211.36%
8J Latus316354227.003.3848.0001-201.36%
9J M Park17190.3494564111.122.3927.8826-4927.89%
10J P Sowter17103163571918.793.4732.5317-8812.93%
11L Laybourne126211221544.203.5674.4003-603.40%
12M Arundell91425486.753.8610.5004-105.44%
13P Fuller1477102681222.333.4838.5004-768.16%
14P Scrowston1825481516.203.2430.0003-383.40%
15R Barker1058102021414.433.4824.8605-229.52%
16S Hewitt19175.1444673413.742.6730.9113-1123.13%
17S Latus13.501142.752.875.7504-112.72%
2005 Bowling

Replies
2
Views
73
Replies
10
Views
233
Replies
1
Views
84
Replies
6
Views
139
Replies
1
Views
311

1,118,529
Messages
5,572,655
Members
412,481
Latest member
nhantam