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 |
