View Single Post
 
Old 09-01-2024, 02:34 AM
Alansidman's Avatar
Alansidman Alansidman is offline Windows 11 Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 111
Alansidman has a spectacular aura aboutAlansidman has a spectacular aura aboutAlansidman has a spectacular aura about
Default

Rather than have us blindly prepare a file for you, why dont you upload a sample file(s) for us to work with. In this manner, we will not have to guess at what your data looks like. Then for the file(s) submitted prepare a mocked up solution of what your file product should look like.

Without an example of your data, then perhaps
Code:
let
    T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    T3 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    T4= Table.Combine({T3,T1,T2})

in
    T4
__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505
Reply With Quote