Get Data - but into column format?

[macdian]

Hi all,

Apologies if this has been posted before - feel free to link it. I have multiple (ie 300) separate spreadsheets which were sent out to individuals as a template, with Column A and B having labels, and then Column C having the data I want. Columns D onward were created to also have data, but none of my spreadsheets will have data in those columns.

The template is used as part of a tool for import into another program. But I need the data from each sheet to add into Column D, E, F, etc. onward, as the tool will only recognize the data in columns, not in additional rows below.

Is this possible? I figured out how to Get Data from Folder, and then was able to exclude the additional columns from my sample file, but can't figure out how to get it to add going horizontally not vertically.

Thanks!

(ps. wonder how many people have a date earlier than my "joined date" )

 

[JEC]

Lets take these two tables as an example:

let
    Source = Excel.CurrentWorkbook(),   //This line should be changed to a From Folder connection
    fltr = Table.SelectRows(Source, each ([Name] <> "Table1_1"))[Content],   //This is where you select your tables
    trf = List.Transform(fltr, (x)=> Table.Transpose(Table.DemoteHeaders(x))),
    combine = Table.Combine(trf),
    transpose = Table.Transpose(combine),
    headers = Table.PromoteHeaders(transpose)
in
    headers

Book1
	A	B	C	D	E	F	G	H
1	a	b	c			a	b	c
2	1	4	5			5	99	44
3	2	3	6			6	2546	2323
4
5
6
7
8	a	b	c	a_1	b_2	c_3
9	1	4	5	5	99	44
10	2	3	6	6	2546	2323
Sheet1