Compilation of sheets with specific Details

[RekhaS]

Hi Folks,

i have a requirement where in i need to combine the data for few sheets to create a .hyper file for my tableau report. Sample sheet is attached. I need to combine the data for tab A-F only with all the headers and metrics given in each sheets including the sheet name in the same tabular format where the years will be in columns and metrics will be rows. Please advise if anyone has optimised solution for the same

[binuacs]

@RekhaS One way of doing this with the batch macro

[RekhaS]

Date format got changed in the output , can you specify the reason. Though solution looks like it will work. Thanks

[binuacs · Accepted solution]

@RekhaS Updated the workflow to reflect the correct date format