Batch Macro/ Iterative Macro

[BRRLL99]

Hi

I have following data set , I'm looking to Map particular columns with different dataset

old parent	old child	old quantity	child	quantity	child2	quantity2	child3	quantity3
SD0789	SD0034	1	SD0055	1	SD0044	1
SD0445	SD0067	0.5	SD0099	2
SD0993	SD0078	2	SD0088	3	SD0034	2	SD0022	4

data	type
SD0034	Black
SD0067	White
SD0078	Black
SD0055	Black
SD0099	Black
SD0088	White
SD0044	White
SD0034	White
SD0022	White

Expected Out:

I can get my expected out using crosstab, but in my original data, I have 10 columns and 1 million rows ,

I'm looking for my expected output in Batch or iterative macro

@BS_THE_ANALYST @PhilipMannering 

old parent

old child

old quantity

type

child

quantity

type

child2

quantity2

type

child3

quantity3

type

SD0789

SD0034

1

Black

SD0055

1

Black

SD0044

1

White

SD0445

SD0067

0.5

White

SD0099

2

Black

SD0993

SD0078

2

Black

SD0088

3

White

SD0034

2

Black

SD0022

4

White

[ArtApa]

Hi @BRRLL99 - If the number of columns is fixed, you can simply have multiple Joins and Unions in your workflow to achieve a desired outcome. No need to overcomplicate. 

[BRRLL99]

my number of columns changes based on the my previous iteration Macro

that's why im looking for any macro, which can map dynamically

[Christina_H · Accepted solution]

It isn't a macro, but I think this does what you need