How to Combine data from two excel worksheets 1

[JRUKUSA]

Trying to combine data and expand rows, example of two work sheets and the desired result.

Worksheet 1
Job Role Step
Coordinator Update Pricing
Buyer Update Pricing

Worksheet 2
Step Course
Update Pricing ME52N
Update Pricing ME53N

Result - Worksheet 3
Job Role Step Course
Coordinator Update Pricing ME52N
Coordinator Update Pricing ME53N
Buyer Update Pricing ME52N
Buyer Update Pricing ME53N

Many thanks in advance for help.

 

[SkipVought]

Hi,

Use MS Query. faq68-5829

SELECT
  `Sheet1$`.`Job Role`
, `Sheet1$`.Step
, `Sheet2$`.Course

FROM `D:\My Documents\Cartesian`.`Sheet1$` `Sheet1$`
,    `D:\My Documents\Cartesian`.`Sheet2$` `Sheet2$`

WHERE `Sheet1$`.Step = `Sheet2$`.Step

Results
[tt]
Job Role Step Course
Buyer Update Pricing ME52N
Coordinator Update Pricing ME52N
Buyer Update Pricing ME53N
Coordinator Update Pricing ME53N
[/tt]


Skip,

_[red][/red]

 

[JRUKUSA]

Skip,

Saved my afternoon,

Many thanks

JR