I am trying to create a more flexible option that allows a control workbook to select which tables it'll do the transformation to. I am stuck on trying to convert the old transformation process into a batch macro so that it can adjust to have more or less than 6 tables imported.
Solved! Go to Solution.
@mquast Attaching the batch macro which will combine all the sheets data with the sheet name, so based on the sheet name you can apply your logic to the combined output
@binuacs This is good, but I don't believe I can create the correct output. I'll attach the correct output below, but after transposing the data, there must be a row that matches age between each sheet. Look under the output tab
Nvm I found a way