Forum Discussion

fsim's avatar
fsim
Responsive Resident
6 years ago
Solved

table.ExpanTableColumn with changing columns' names

hi there, Every month I get a brunch of 20 xls files containing 12+ columns. The name of those columns changed every month (typically previous 5 months, current month, next 6 months ) . How can I us...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi fsim 

 

Please, see the attached file with a solution, it will look at all the column names within the tables and use this as a list to expand columns

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

  • fsim's avatar
    fsim
    Responsive Resident
    6 years ago

    Hi Mariusz  this is perfect, 

    Thank you so much.