Import the first and last 3 columns w/ PQ from a data set that gets new columns all the time - L0009

Опубликовано: 10 Ноябрь 2024
на канале: Celia Alves - Solve & Excel

1,369

In Today´s class we are going to talk about: how we can build a query that brings always the first and the last three columns from a table that keeps having new columns every new month. We will see two examples: one where the last columns to consider are dates, and another example where the last columns have random names.
In Today´s class we are going to talk about: how we can build a query that brings always the first and the last three columns from a table that keeps having new columns every new month. We will see two examples: one where the last columns to consider are dates, and another example where the last columns have random names.

Get access to the exercise files by joining my Telegram Group at
https://t.me/celiaalvessolveexcel

Subscribe to my Newsletter for exciting news about the Excel world
https://bit.ly/learnfromcelia

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel